DBA Data[Home] [Help]

APPS.EAM_WORKORDER_UTIL_PKG dependencies on BOM_BILL_OF_MATERIALS

Line 101: bom_bill_of_materials bbom,

97: msik.primary_uom_code uom,
98: bic.wip_supply_type,
99: lu.meaning wip_supply_type_disp
100: from bom_inventory_components bic,
101: bom_bill_of_materials bbom,
102: mtl_system_items_kfv msik,
103: mfg_lookups lu
104: where bbom.assembly_item_id = i_phantom_item_id
105: and bbom.organization_id = i_organization_id

Line 141: from bom_bill_of_materials

137: -- Get the Bill-Sequence
138: begin
139: select common_bill_sequence_id
140: into l_bill_sequence_id
141: from bom_bill_of_materials
142: where organization_id = i_organization_id
143: and assembly_item_id = i_asset_group_id
144: and alternate_bom_designator is null;
145: exception

Line 260: from bom_bill_of_materials bbom,

256: l_component_item_id NUMBER;
257: BEGIN
258: select bic.component_item_id
259: into l_component_item_id
260: from bom_bill_of_materials bbom,
261: bom_inventory_components bic
262: where bbom.assembly_item_id = i_assembly_item_id
263: and bbom.organization_id = i_organization_id
264: and bbom.alternate_bom_designator is null

Line 289: from bom_bill_of_materials

285: l_item_sequence_num := 100;
286:
287: select common_bill_sequence_id
288: into l_bill_sequence_id
289: from bom_bill_of_materials
290: where organization_id = i_organization_id
291: and assembly_item_id = i_assembly_item_id
292: and alternate_bom_designator is null;
293: