DBA Data[Home] [Help]

APPS.FLM_EXECUTION_UTIL dependencies on BOM_INVENTORY_COMPONENTS

Line 790: from bom_explosions be, bom_inventory_components bic

786: CURSOR bom_cursor (bill_seq IN NUMBER,
787: exp_type IN VARCHAR2,
788: sort_ord IN VARCHAR2) IS
789: select count(top_bill_sequence_id) count
790: from bom_explosions be, bom_inventory_components bic
791: where top_bill_sequence_id = bill_seq
792: and explosion_type = exp_type
793: and sort_order = sort_ord
794: and be.component_sequence_id = bic.component_sequence_id

Line 2168: from bom_inventory_components bic,

2164: and nvl(bbom.alternate_bom_designator, 'NULL') = nvl(wfs.alternate_bom_designator, 'NULL');
2165:
2166: CURSOR nontxn_comp_cnt IS
2167: select count(component_item_id) comp_cnt
2168: from bom_inventory_components bic,
2169: mtl_system_items msi
2170: where bill_sequence_id = l_bill_seq_id
2171: and msi.inventory_item_id = bic.component_item_id
2172: and bic.effectivity_date < nvl(l_bom_rev_date,sysdate)