APPS.CTO_TRANSFER_PRICE_PK dependencies on MTL_SYSTEM_ITEMS

Line 795: mtl_system_items msi

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
799: and bbom.common_bill_sequence_id = bic.bill_sequence_id

Line 849: mtl_system_items msi, -- bet component join

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
852: bbom.assembly_item_id = bet.component_item_id
853: and bbom.organization_id =

Line 850: mtl_system_items msi2 -- bic component join

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
852: bbom.assembly_item_id = bet.component_item_id
853: and bbom.organization_id =
854: (select bbom1.organization_id

Line 918: mtl_system_items msi

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
922: and bbom.common_bill_sequence_id = bic.bill_sequence_id

Line 972: mtl_system_items msi

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
975: and bbom.organization_id =
976: (select bbom1.organization_id

Line 1124: from mtl_system_items

1120: Primary_uom_code
1121: into l_base_item_id,
1122: l_build_in_wip,
1123: l_prim_uom
1124: from mtl_system_items
1125: where inventory_item_id = p_config_item_id
1126: and organization_id = p_from_organization_id; -- org to create the AR
1127: If PG_DEBUG <> 0 Then
1128: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'base_item_id::'||l_base_item_id);