[Home] [Help]
View: MRP_AP_OPERATION_RESOURCES_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.RESOURCE_ID
, BOR.USAGE_RATE_OR_AMOUNT RESOURCE_USAGE
, BOR.BASIS_TYPE
, BOR.ASSIGNED_UNITS RESOURCE_UNITS
, BR.UNIT_OF_MEASURE UOM_CODE
, BR.RN RN5
, BOR.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_RESS_SN BR
, 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 BR.RESOURCE_ID= BOR.RESOURCE_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 |
RESOURCE_ID |
RESOURCE_USAGE |
BASIS_TYPE |
RESOURCE_UNITS |
UOM_CODE |
RN5 |
RN4 |
RN3 |
RN2 |
RN1 |