APPS.BOMPNORD dependencies on BOM_BILL_OF_MATERIALS

Line 104: FROM bom_bill_of_materials

100: X_SortWidth constant number := Bom_Common_Definitions.G_Bom_SortCode_Width;
101:
102: CURSOR get_bill_id IS
103: SELECT bill_sequence_id
104: FROM bom_bill_of_materials
105: WHERE assembly_item_id = ITEM_ID
106: AND organization_id = ORG_ID
107: AND alternate_bom_designator is null;
108:

Line 130: FROM bom_bill_of_materials bbom

126: and sort_order = lpad('1', X_SortWidth, '0');
127:
128: CURSOR lock_bom IS
129: SELECT 1
130: FROM bom_bill_of_materials bbom
131: WHERE organization_id = ORG_ID
132: AND assembly_item_id = ITEM_ID
133: AND alternate_bom_designator is NULL
134: FOR UPDATE OF assembly_item_id NOWAIT;