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.

VIEW: APPS.BOM_COMPONENT_ALL_OPERATIONS_V

Source

View Text - Preformatted


SELECT BIC.BILL_SEQUENCE_ID BILL_SEQUENCE_ID, BIC.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, BIC.COMPONENT_ITEM_ID COMPONENT_ITEM_ID, BIC.OPERATION_SEQ_NUM OPERATION_SEQ_NUM, BIC.EFFECTIVITY_DATE EFFECTIVITY_DATE, BIC.DISABLE_DATE DISABLE_DATE, BIC.FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER, BIC.TO_END_ITEM_UNIT_NUMBER TO_END_ITEM_UNIT_NUMBER, BIC.IMPLEMENTATION_DATE IMPLEMENTATION_DATE, BIC.ECO_FOR_PRODUCTION ECO_FOR_PRODUCTION, 0 COMP_OPERATION_SEQ_ID, BIC.ROWID ROW_ID, 'COMPONENT' ENTITY_IDENTIFIER FROM BOM_INVENTORY_COMPONENTS BIC UNION SELECT BCO.BILL_SEQUENCE_ID BILL_SEQUENCE_ID, BCO.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, BIC.COMPONENT_ITEM_ID COMPONENT_ITEM_ID, BCO.OPERATION_SEQ_NUM OPERATION_SEQ_NUM, BIC.EFFECTIVITY_DATE EFFECTIVITY_DATE, BIC.DISABLE_DATE DISABLE_DATE, BIC.FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER, BIC.TO_END_ITEM_UNIT_NUMBER TO_END_ITEM_UNIT_NUMBER, BIC.IMPLEMENTATION_DATE IMPLEMENTATION_DATE, BIC.ECO_FOR_PRODUCTION ECO_FOR_PRODUCTION, BCO.COMP_OPERATION_SEQ_ID COMP_OPERATION_SEQ_ID, BCO.ROWID ROW_ID, 'OPERATION' ENTITY_IDENTIFIER FROM BOM_COMPONENT_OPERATIONS BCO, BOM_INVENTORY_COMPONENTS BIC WHERE BCO.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID

View Text - HTML Formatted

SELECT BIC.BILL_SEQUENCE_ID BILL_SEQUENCE_ID
, BIC.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, BIC.COMPONENT_ITEM_ID COMPONENT_ITEM_ID
, BIC.OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, BIC.EFFECTIVITY_DATE EFFECTIVITY_DATE
, BIC.DISABLE_DATE DISABLE_DATE
, BIC.FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER
, BIC.TO_END_ITEM_UNIT_NUMBER TO_END_ITEM_UNIT_NUMBER
, BIC.IMPLEMENTATION_DATE IMPLEMENTATION_DATE
, BIC.ECO_FOR_PRODUCTION ECO_FOR_PRODUCTION
, 0 COMP_OPERATION_SEQ_ID
, BIC.ROWID ROW_ID
, 'COMPONENT' ENTITY_IDENTIFIER
FROM BOM_INVENTORY_COMPONENTS BIC UNION SELECT BCO.BILL_SEQUENCE_ID BILL_SEQUENCE_ID
, BCO.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, BIC.COMPONENT_ITEM_ID COMPONENT_ITEM_ID
, BCO.OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, BIC.EFFECTIVITY_DATE EFFECTIVITY_DATE
, BIC.DISABLE_DATE DISABLE_DATE
, BIC.FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER
, BIC.TO_END_ITEM_UNIT_NUMBER TO_END_ITEM_UNIT_NUMBER
, BIC.IMPLEMENTATION_DATE IMPLEMENTATION_DATE
, BIC.ECO_FOR_PRODUCTION ECO_FOR_PRODUCTION
, BCO.COMP_OPERATION_SEQ_ID COMP_OPERATION_SEQ_ID
, BCO.ROWID ROW_ID
, 'OPERATION' ENTITY_IDENTIFIER
FROM BOM_COMPONENT_OPERATIONS BCO
, BOM_INVENTORY_COMPONENTS BIC
WHERE BCO.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID