SF_RTG_RESRC_VW(SQL View) |
Index Back |
|---|---|
SF Routing Resource ViewCN#EG750-4.0 dbe (Engineering Routings) - Added RTG_STATE. 10/7/97 ebn CN#EN750-1.0 : Changed view to take into account the Reference Routing Item on BU_ITEMS_INV for Master Routing Enhancement. |
| SELECT A.BUSINESS_UNIT, A.INV_ITEM_ID, B.RTG_TYPE, B.RTG_CODE, B.RTG_STATE, B.OP_SEQUENCE, B.RESRC_TYPE, B.CREW_CODE, B.MACHINE_CODE, B.TOOL_CODE, B.TOOL_QTY FROM PS_BU_ITEMS_INV A, PS_EN_RTG_RESRC B where b.business_unit = a.business_unit and b.inv_item_id = a.ref_routing_item and (resrc_type = '10' or resrc_type = '30' or resrc_type = '50') and rtg_state='PR' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_OPT_MG |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MASTER_ITEM_TBL |
| 3 | RTG_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Routing Type
PR=Production RW=Rework TD=Teardown Default Value: PR |
| 4 | RTG_CODE |
Number(2,0) | SMALLINT NOT NULL |
Routing Code
Default Value: 1 |
| 5 | RTG_STATE |
Character(2) | VARCHAR2(2) NOT NULL |
Routing State
EN=Engineering PR=Manufacturing Default Value: PR |
| 6 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 7 | SF_RESRC_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Resource Type
10=Crew 30=Machine 50=Tool |
| 8 | CREW_CODE |
Character(10) | VARCHAR2(10) NOT NULL |
Crew Name
Prompt Table: EN_WC_CREW_VW |
| 9 | MACHINE_CODE |
Character(10) | VARCHAR2(10) NOT NULL |
Machine Code
Prompt Table: EN_WC_MACH_VW |
| 10 | TOOL_CODE |
Character(10) | VARCHAR2(10) NOT NULL |
Tool ID
Prompt Table: EN_WC_TOOL_VW |
| 11 | TOOL_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Quantity Used |