ROUTING_SETIDINV_ITEM_IDROUTING_IDOP_SEQA=Active
I=Inactive
O=Per Batch
P=Per Unit
ROUTING_LN_VW(SQL View) |
Index Back |
|---|---|
Item Routing Line Vw |
| SELECT A.SETID , A.INV_ITEM_ID , B.ROUTING_ID , B.OP_SEQ , B.EFFDT , B.EFF_STATUS , B.OP_TIME_STD , B.OP_TIME_CD , B.OP_INSTRUCTIONS FROM PS_PURCH_ITEM_ATTR A , PS_ROUTING_LN B WHERE A.SETID = B.SETID AND A.ROUTING_ID = B.ROUTING_ID AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_ROUTING_LN C WHERE B.SETID = C.SETID AND B.ROUTING_ID = C.ROUTING_ID AND C.EFFDT <= %CurrentDateIn AND C.EFF_STATUS = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ROUTING_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Routing SetID |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | ROUTING_ID |
Character(10) | VARCHAR2(10) NOT NULL | Inspection Routing ID |
| 4 | OP_SEQ |
Number(3,0) | SMALLINT NOT NULL | Op Seq |
| 5 | EFFDT | Date(10) | DATE | Effective Date |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 7 | OP_TIME_STD | Number(6,2) | DECIMAL(5,2) NOT NULL | Standard Operation Run Time |
| 8 | OP_TIME_CD | Character(1) | VARCHAR2(1) NOT NULL |
Operation Time Type
O=Per Batch P=Per Unit |
| 9 | OP_INSTRUCTIONS | Long Character | CLOB | Operation Instructions |