PL_PR_C_OP_VW

(SQL View)
Index Back

Operation prompt table view

For Component grid on the Production Order Header page.

SELECT PROBINST ,BUSINESS_UNIT ,PRODUCTION_ID ,OP_SEQUENCE ,COMPONENT_ID FROM PS_PL_PR_COMP_LIST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
4 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
5 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.