DBA Data[Home] [Help]

APPS.BOM_SUB_COMPS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 21: FROM mtl_system_items

17:
18: BEGIN
19: SELECT primary_uom_code
20: INTO X_uom_code
21: FROM mtl_system_items
22: WHERE inventory_item_id = X_sub_comp_id
23: AND organization_id = X_org_id;
24:
25: END Get_Uom;

Line 64: FROM mtl_system_items msi

60: WHERE bbom.common_bill_sequence_id = X_bill_seq_id
61: AND bbom.organization_id <> X_org_id
62: AND not exists
63: (SELECT null
64: FROM mtl_system_items msi
65: WHERE msi.organization_id = bbom.organization_id
66: AND msi.inventory_item_id = X_sub_comp_id
67: AND msi.bom_enabled_flag = 'Y'
68: AND ((bbom.assembly_type = 1

Line 462: FROM Bom_Bill_Of_Materials bbm, Bom_Inventory_Components bic, Mtl_System_Items_Kfv msi

458: SELECT bic.Bill_Sequence_Id, bbm.Organization_Id, bic.Component_Item_Id,
459: bic.Component_Remarks, msi.Concatenated_Segments
460: INTO l_Bill_Sequence_Id, l_Organization_Id, l_Component_Item_Id,
461: l_Component_Remarks, l_Component_Item_Name
462: FROM Bom_Bill_Of_Materials bbm, Bom_Inventory_Components bic, Mtl_System_Items_Kfv msi
463: WHERE bbm.Bill_Sequence_Id = bic.Bill_Sequence_Id
464: And msi.Inventory_Item_Id = bic.Component_Item_Id
465: And msi.Organization_Id = bbm.Organization_Id
466: And bic.Component_Sequence_Id = p_Component_Sequence_Id;