APPS.CTO_TRANSFER_PRICE_PK dependencies on BOM_BILL_OF_MATERIALS

Line 158: from bom_bill_of_materials

154:
155: BEGIN
156: select organization_id
157: into p_organization_id
158: from bom_bill_of_materials
159: where assembly_item_id = p_item_id
160: and rownum = 1;
161:
162: IF PG_DEBUG <> 0 THEN

Line 281: from bom_bill_of_materials

277: lStmtNumber := 110;
278: BEGIN
279: select organization_id
280: into p_organization_id
281: from bom_bill_of_materials
282: where assembly_item_id = p_item_id
283: and rownum = 1;
284:
285: IF PG_DEBUG <> 0 THEN

Line 794: bom_bill_of_materials bbom,

790: p_grp_id,
791: bic.basis_type /* LBM Project change */
792: from
793: bom_inventory_components bic,
794: bom_bill_of_materials bbom,
795: mtl_system_items msi
796: where bbom.assembly_item_id = p_item_id
797: and bbom.organization_id = p_organization_id
798: and bbom.alternate_bom_designator is null

Line 847: bom_bill_of_materials bbom,

843: p_grp_id,
844: bic.basis_type /* LBM Project change */
845: from
846: bom_inventory_components bic,
847: bom_bill_of_materials bbom,
848: bom_explosion_temp bet,
849: mtl_system_items msi, -- bet component join
850: mtl_system_items msi2 -- bic component join
851: where

Line 855: from bom_bill_of_materials bbom1

851: where
852: bbom.assembly_item_id = bet.component_item_id
853: and bbom.organization_id =
854: (select bbom1.organization_id
855: from bom_bill_of_materials bbom1
856: where bbom1.assembly_item_id = bet.component_item_id
857: and bbom1.alternate_bom_designator is null
858: and rownum = 1)
859: and bbom.common_bill_sequence_id = bic.bill_sequence_id

Line 917: bom_bill_of_materials bbom,

913: p_grp_id,
914: bic.basis_type /* LBM Project change */
915: from
916: bom_inventory_components bic,
917: bom_bill_of_materials bbom,
918: mtl_system_items msi
919: where bbom.assembly_item_id = p_item_id
920: and bbom.organization_id = p_organization_id
921: and bbom.alternate_bom_designator is null

Line 970: bom_bill_of_materials bbom,

966: p_grp_id,
967: bic.basis_type /* LBM Project change */
968: from
969: bom_inventory_components bic,
970: bom_bill_of_materials bbom,
971: bom_explosion_temp bet,
972: mtl_system_items msi
973: where
974: bbom.assembly_item_id = bet.component_item_id

Line 977: from bom_bill_of_materials bbom1

973: where
974: bbom.assembly_item_id = bet.component_item_id
975: and bbom.organization_id =
976: (select bbom1.organization_id
977: from bom_bill_of_materials bbom1
978: where bbom1.assembly_item_id = bet.component_item_id
979: and bbom1.alternate_bom_designator is null
980: and rownum = 1)
981: and bbom.common_bill_sequence_id = bic.bill_sequence_id