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.WSM_COMPONENTS_V

Source

View Text - Preformatted


SELECT bom1.assembly_item_id, bic.component_item_id, bom1.organization_id, bic.component_quantity, decode(bic.component_yield_factor, 0, 1, bic.component_yield_factor) COMPONENT_YIELD_FACTOR, bom1.alternate_bom_designator, bic.basis_type from mtl_System_items msi, bom_inventory_components bic, bom_bill_of_materials bom1 /*, bom_bill_of_materials bom2 commented for bug fix 5901823 */ WHERE bic.bill_sequence_id = bom1.common_bill_sequence_id /* removed join condition between two bom tables for performance bug 590182. bic.bill_sequence_id = bom2.bill_sequence_id and bom1.common_bill_sequence_id = bom2.bill_sequence_id */ /* CZH: I-OED-2, should allow componet that is effective as of bom_rev_date */ /*AND bic.EFFECTIVITY_DATE <= SYSDATE AND nvl(DISABLE_DATE, SYSDATE + 1) > SYSDATE */ and msi.organization_id = bom1.organization_id and msi.inventory_item_id = bom1.assembly_item_id and msi.build_in_wip_flag = 'Y' and msi.pick_components_flag = 'N' and bic.implementation_date is not null /*adding the following join with UNION ALL for 12.1 substitute component project */ UNION ALL SELECT bom.assembly_item_id, bsc.substitute_component_id, bom.organization_id, bsc.substitute_item_quantity, decode(bic.component_yield_factor, 0, 1, bic.component_yield_factor) COMPONENT_YIELD_FACTOR, bom.alternate_bom_designator, bic.basis_type FROM mtl_System_items msi, bom_inventory_components bic, bom_bill_of_materials bom, bom_substitute_components bsc WHERE bic.component_sequence_id = bsc.component_sequence_id and bic.bill_sequence_id = bom.common_bill_sequence_id and msi.organization_id = bom.organization_id and msi.inventory_item_id = bom.assembly_item_id and msi.build_in_wip_flag = 'Y' and msi.pick_components_flag = 'N' and bic.implementation_date is not null

View Text - HTML Formatted

SELECT BOM1.ASSEMBLY_ITEM_ID
, BIC.COMPONENT_ITEM_ID
, BOM1.ORGANIZATION_ID
, BIC.COMPONENT_QUANTITY
, DECODE(BIC.COMPONENT_YIELD_FACTOR
, 0
, 1
, BIC.COMPONENT_YIELD_FACTOR) COMPONENT_YIELD_FACTOR
, BOM1.ALTERNATE_BOM_DESIGNATOR
, BIC.BASIS_TYPE
FROM MTL_SYSTEM_ITEMS MSI
, BOM_INVENTORY_COMPONENTS BIC
, BOM_BILL_OF_MATERIALS BOM1 /*
, BOM_BILL_OF_MATERIALS BOM2 COMMENTED FOR BUG FIX 5901823 */
WHERE BIC.BILL_SEQUENCE_ID = BOM1.COMMON_BILL_SEQUENCE_ID /* REMOVED JOIN CONDITION BETWEEN TWO BOM TABLES FOR PERFORMANCE BUG 590182. BIC.BILL_SEQUENCE_ID = BOM2.BILL_SEQUENCE_ID
AND BOM1.COMMON_BILL_SEQUENCE_ID = BOM2.BILL_SEQUENCE_ID */ /* CZH: I-OED-2
, SHOULD ALLOW COMPONET THAT IS EFFECTIVE AS OF BOM_REV_DATE */ /*AND BIC.EFFECTIVITY_DATE <= SYSDATE
AND NVL(DISABLE_DATE
, SYSDATE + 1) > SYSDATE */
AND MSI.ORGANIZATION_ID = BOM1.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = BOM1.ASSEMBLY_ITEM_ID
AND MSI.BUILD_IN_WIP_FLAG = 'Y'
AND MSI.PICK_COMPONENTS_FLAG = 'N'
AND BIC.IMPLEMENTATION_DATE IS NOT NULL /*ADDING THE FOLLOWING JOIN WITH UNION ALL FOR 12.1 SUBSTITUTE COMPONENT PROJECT */ UNION ALL SELECT BOM.ASSEMBLY_ITEM_ID
, BSC.SUBSTITUTE_COMPONENT_ID
, BOM.ORGANIZATION_ID
, BSC.SUBSTITUTE_ITEM_QUANTITY
, DECODE(BIC.COMPONENT_YIELD_FACTOR
, 0
, 1
, BIC.COMPONENT_YIELD_FACTOR) COMPONENT_YIELD_FACTOR
, BOM.ALTERNATE_BOM_DESIGNATOR
, BIC.BASIS_TYPE
FROM MTL_SYSTEM_ITEMS MSI
, BOM_INVENTORY_COMPONENTS BIC
, BOM_BILL_OF_MATERIALS BOM
, BOM_SUBSTITUTE_COMPONENTS BSC
WHERE BIC.COMPONENT_SEQUENCE_ID = BSC.COMPONENT_SEQUENCE_ID
AND BIC.BILL_SEQUENCE_ID = BOM.COMMON_BILL_SEQUENCE_ID
AND MSI.ORGANIZATION_ID = BOM.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = BOM.ASSEMBLY_ITEM_ID
AND MSI.BUILD_IN_WIP_FLAG = 'Y'
AND MSI.PICK_COMPONENTS_FLAG = 'N'
AND BIC.IMPLEMENTATION_DATE IS NOT NULL