APPS.WSMPLBJI dependencies on BOM_INVENTORY_COMPONENTS

Line 4882: FROM BOM_INVENTORY_COMPONENTS BIC,

4878: if l_error_code = 0 then
4879: begin
4880: SELECT 1
4881: INTO l_dummy
4882: FROM BOM_INVENTORY_COMPONENTS BIC,
4883: MTL_SYSTEM_ITEMS C
4884: WHERE BIC.COMPONENT_ITEM_ID = C.INVENTORY_ITEM_ID
4885: AND C.ORGANIZATION_ID = v_wlji_org(v_index)
4886: AND BIC.BILL_SEQUENCE_ID = bom_seq_id

Line 4901: FROM BOM_INVENTORY_COMPONENTS BIC2,

4897: and nvl(BIC.DISABLE_DATE, l_bom_rev_date + 1)
4898: -- EC: BUGFIX 2380517
4899: AND EFFECTIVITY_DATE =(
4900: SELECT MAX (EFFECTIVITY_DATE)
4901: FROM BOM_INVENTORY_COMPONENTS BIC2,
4902: ENG_REVISED_ITEMS ERI
4903: WHERE BIC2.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
4904: AND BIC2.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
4905: AND (decode(BIC2.IMPLEMENTATION_DATE,

Line 4919: FROM BOM_INVENTORY_COMPONENTS BICN,

4915: ERI.REVISED_ITEM_SEQUENCE_ID(+)
4916: AND ( NVL(ERI.STATUS_TYPE,6) IN (4,6,7))
4917: AND NOT EXISTS (
4918: SELECT 'X'
4919: FROM BOM_INVENTORY_COMPONENTS BICN,
4920: ENG_REVISED_ITEMS ERI1
4921: WHERE BICN.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
4922: AND BICN.OLD_COMPONENT_SEQUENCE_ID =
4923: BIC.COMPONENT_SEQUENCE_ID

Line 5000: bom_inventory_components bic,

4996: INTO l_component_quantity,
4997: l_component_yield_factor,
4998: l_comp_basis_type -- LBM enh
4999: from mtl_System_items msi,
5000: bom_inventory_components bic,
5001: bom_bill_of_materials bom,
5002: bom_bill_of_materials bom2
5003: WHERE bic.bill_sequence_id = bom2.bill_sequence_id
5004: and bom.common_bill_sequence_id = bom2.bill_sequence_id

Line 5143: FROM BOM_INVENTORY_COMPONENTS BIC,

5139: -- *** validate starting lot is not phantom begin ***
5140: begin
5141: SELECT 1
5142: INTO l_dummy
5143: FROM BOM_INVENTORY_COMPONENTS BIC,
5144: MTL_SYSTEM_ITEMS C
5145: WHERE BIC.COMPONENT_ITEM_ID = C.INVENTORY_ITEM_ID
5146: AND C.ORGANIZATION_ID = v_wlji_org(v_index)
5147: AND BIC.BILL_SEQUENCE_ID = bom_seq_id

Line 5163: FROM BOM_INVENTORY_COMPONENTS BIC2,

5159: and nvl(BIC.DISABLE_DATE, l_bom_rev_date + 1)
5160: -- EC: BUGFIX 2380517
5161: AND EFFECTIVITY_DATE = (
5162: SELECT MAX(EFFECTIVITY_DATE)
5163: FROM BOM_INVENTORY_COMPONENTS BIC2,
5164: ENG_REVISED_ITEMS ERI
5165: WHERE BIC2.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
5166: AND BIC2.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
5167: AND (decode(BIC2.IMPLEMENTATION_DATE,

Line 5180: FROM BOM_INVENTORY_COMPONENTS BICN,

5176: AND BIC2.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)
5177: AND (NVL(ERI.STATUS_TYPE,6) IN (4,6,7))
5178: AND NOT EXISTS (
5179: SELECT 'X'
5180: FROM BOM_INVENTORY_COMPONENTS BICN,
5181: ENG_REVISED_ITEMS ERI1
5182: WHERE BICN.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
5183: AND BICN.OLD_COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID
5184: AND BICN.ACD_TYPE in (2,3)