[Home] [Help]
View: MRP_AP_OP_RESOURCE_SEQS_V
Product: | MRP - Master Scheduling/MRP |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT BORTN.ROUTING_SEQUENCE_ID
, BOR.OPERATION_SEQUENCE_ID
, BOR.RESOURCE_SEQ_NUM
, BOR.SCHEDULE_FLAG
, BOR.RESOURCE_OFFSET_PERCENT
, BOS.DEPARTMENT_ID
, BOR.RN RN5
, BOS.RN RN4
, BORTN.RN RN3
, MSIK.RN RN2
, MP.RN RN1
FROM MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MSIK
, MRP_AP_OPR_RESS_SN BOR
, MRP_AP_OPR_SEQS_SN BOS
, MRP_AP_OPR_RTNS_SN BORTN
WHERE MSIK.ORGANIZATION_ID = BORTN.ORGANIZATION_ID
AND MSIK.INVENTORY_ITEM_ID= BORTN.ASSEMBLY_ITEM_ID
AND BOS.OPERATION_SEQUENCE_ID= BOR.OPERATION_SEQUENCE_ID
AND BORTN.COMMON_ROUTING_SEQUENCE_ID= BOS.ROUTING_SEQUENCE_ID
AND BORTN.ORGANIZATION_ID= MP.ORGANIZATION_ID
Columns
Name |
ROUTING_SEQUENCE_ID |
OPERATION_SEQUENCE_ID |
RESOURCE_SEQ_NUM |
SCHEDULE_FLAG |
RESOURCE_OFFSET_PERCENT |
DEPARTMENT_ID |
RN5 |
RN4 |
RN3 |
RN2 |
RN1 |