VIEW: APPS.CS_SR_INV_SUBCOMPONENTS_V

Source

View Text - Preformatted

SELECT kfv.organization_id, kfv.inventory_item_id subcomponent_id, kfv.description description, kfv.concatenated_segments, bom.assembly_item_id component_id FROM mtl_system_items_vl kfv, bom_inventory_components bic, bom_bill_of_materials bom WHERE bom.organization_id = kfv.organization_id AND bic.bill_sequence_id = bom.common_bill_sequence_id AND trunc(sysdate) between trunc( bic.effectivity_date) and nvl(bic.disable_date,trunc(sysdate)) AND kfv.inventory_item_id = bic.component_item_id AND bom.alternate_bom_designator IS NULL and EXISTS (select comp.component_id from cs_sr_inv_components_v comp where comp.organization_id = kfv.organization_id and comp.component_id = bom.assembly_item_id)

View Text - HTML Formatted

SELECT KFV.ORGANIZATION_ID
, KFV.INVENTORY_ITEM_ID SUBCOMPONENT_ID
, KFV.DESCRIPTION DESCRIPTION
, KFV.CONCATENATED_SEGMENTS
, BOM.ASSEMBLY_ITEM_ID COMPONENT_ID
FROM MTL_SYSTEM_ITEMS_VL KFV
, BOM_INVENTORY_COMPONENTS BIC
, BOM_BILL_OF_MATERIALS BOM
WHERE BOM.ORGANIZATION_ID = KFV.ORGANIZATION_ID
AND BIC.BILL_SEQUENCE_ID = BOM.COMMON_BILL_SEQUENCE_ID
AND TRUNC(SYSDATE) BETWEEN TRUNC( BIC.EFFECTIVITY_DATE)
AND NVL(BIC.DISABLE_DATE
, TRUNC(SYSDATE))
AND KFV.INVENTORY_ITEM_ID = BIC.COMPONENT_ITEM_ID
AND BOM.ALTERNATE_BOM_DESIGNATOR IS NULL
AND EXISTS (SELECT COMP.COMPONENT_ID
FROM CS_SR_INV_COMPONENTS_V COMP
WHERE COMP.ORGANIZATION_ID = KFV.ORGANIZATION_ID
AND COMP.COMPONENT_ID = BOM.ASSEMBLY_ITEM_ID)