eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MRP_AP_OPERATION_COMPONENTS_V

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT BBOM.ASSEMBLY_ITEM_ID
, BBOM.ORGANIZATION_ID
, BIC.COMPONENT_SEQUENCE_ID
, BOS.OPERATION_SEQUENCE_ID
, BBOM.BILL_SEQUENCE_ID
, BOR.ROUTING_SEQUENCE_ID
, BOS.OPERATION_TYPE
FROM MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MSIK
, MRP_AP_OPR_SEQS_SN BOS
, MRP_AP_INV_COMPS_SN BIC
, MRP_AP_OPR_RTNS_SN BOR
, MRP_AP_BOMS_SN BBOM
WHERE BOR.ASSEMBLY_ITEM_ID= BBOM.ASSEMBLY_ITEM_ID
AND BOR.ORGANIZATION_ID= BBOM.ORGANIZATION_ID
AND BIC.BILL_SEQUENCE_ID= BBOM.COMMON_BILL_SEQUENCE_ID
AND BOS.ROUTING_SEQUENCE_ID= BOR.COMMON_ROUTING_SEQUENCE_ID
AND BOS.OPERATION_SEQ_NUM= BIC.OPERATION_SEQ_NUM
AND BOS.EFFECTIVITY_DATE <= NVL(BIC.DISABLE_DATE
, BOS.EFFECTIVITY_DATE)
AND BIC.EFFECTIVITY_DATE <= NVL(BOS.DISABLE_DATE
, BIC.EFFECTIVITY_DATE)
AND BBOM.ORGANIZATION_ID= MP.ORGANIZATION_ID
AND BBOM.ASSEMBLY_ITEM_ID= MSIK.INVENTORY_ITEM_ID
AND BBOM.ORGANIZATION_ID= MSIK.ORGANIZATION_ID

Columns

Name
ASSEMBLY_ITEM_ID
ORGANIZATION_ID
COMPONENT_SEQUENCE_ID
OPERATION_SEQUENCE_ID
BILL_SEQUENCE_ID
ROUTING_SEQUENCE_ID
OPERATION_TYPE