APPS.WSMPLBJI dependencies on BOM_INVENTORY_COMPONENTS

Line 4888: FROM BOM_INVENTORY_COMPONENTS BIC,

4884: if l_error_code = 0 then
4885: begin
4886: SELECT 1
4887: INTO l_dummy
4888: FROM BOM_INVENTORY_COMPONENTS BIC,
4889: MTL_SYSTEM_ITEMS C
4890: WHERE BIC.COMPONENT_ITEM_ID = C.INVENTORY_ITEM_ID
4891: AND C.ORGANIZATION_ID = v_wlji_org(v_index)
4892: AND BIC.BILL_SEQUENCE_ID = bom_seq_id

Line 4907: FROM BOM_INVENTORY_COMPONENTS BIC2,

4903: and nvl(BIC.DISABLE_DATE, l_bom_rev_date + 1)
4904: -- EC: BUGFIX 2380517
4905: AND EFFECTIVITY_DATE =(
4906: SELECT MAX (EFFECTIVITY_DATE)
4907: FROM BOM_INVENTORY_COMPONENTS BIC2,
4908: ENG_REVISED_ITEMS ERI
4909: WHERE BIC2.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
4910: AND BIC2.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
4911: AND (decode(BIC2.IMPLEMENTATION_DATE,

Line 4925: FROM BOM_INVENTORY_COMPONENTS BICN,

4921: ERI.REVISED_ITEM_SEQUENCE_ID(+)
4922: AND ( NVL(ERI.STATUS_TYPE,6) IN (4,6,7))
4923: AND NOT EXISTS (
4924: SELECT 'X'
4925: FROM BOM_INVENTORY_COMPONENTS BICN,
4926: ENG_REVISED_ITEMS ERI1
4927: WHERE BICN.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
4928: AND BICN.OLD_COMPONENT_SEQUENCE_ID =
4929: BIC.COMPONENT_SEQUENCE_ID

Line 5006: bom_inventory_components bic,

5002: INTO l_component_quantity,
5003: l_component_yield_factor,
5004: l_comp_basis_type -- LBM enh
5005: from mtl_System_items msi,
5006: bom_inventory_components bic,
5007: bom_bill_of_materials bom,
5008: bom_bill_of_materials bom2
5009: WHERE bic.bill_sequence_id = bom2.bill_sequence_id
5010: and bom.common_bill_sequence_id = bom2.bill_sequence_id

Line 5149: FROM BOM_INVENTORY_COMPONENTS BIC,

5145: -- *** validate starting lot is not phantom begin ***
5146: begin
5147: SELECT 1
5148: INTO l_dummy
5149: FROM BOM_INVENTORY_COMPONENTS BIC,
5150: MTL_SYSTEM_ITEMS C
5151: WHERE BIC.COMPONENT_ITEM_ID = C.INVENTORY_ITEM_ID
5152: AND C.ORGANIZATION_ID = v_wlji_org(v_index)
5153: AND BIC.BILL_SEQUENCE_ID = bom_seq_id

Line 5169: FROM BOM_INVENTORY_COMPONENTS BIC2,

5165: and nvl(BIC.DISABLE_DATE, l_bom_rev_date + 1)
5166: -- EC: BUGFIX 2380517
5167: AND EFFECTIVITY_DATE = (
5168: SELECT MAX(EFFECTIVITY_DATE)
5169: FROM BOM_INVENTORY_COMPONENTS BIC2,
5170: ENG_REVISED_ITEMS ERI
5171: WHERE BIC2.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
5172: AND BIC2.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
5173: AND (decode(BIC2.IMPLEMENTATION_DATE,

Line 5186: FROM BOM_INVENTORY_COMPONENTS BICN,

5182: AND BIC2.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)
5183: AND (NVL(ERI.STATUS_TYPE,6) IN (4,6,7))
5184: AND NOT EXISTS (
5185: SELECT 'X'
5186: FROM BOM_INVENTORY_COMPONENTS BICN,
5187: ENG_REVISED_ITEMS ERI1
5188: WHERE BICN.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
5189: AND BICN.OLD_COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID
5190: AND BICN.ACD_TYPE in (2,3)