DBA Data[Home] [Help]

APPS.FLM_EXECUTION_UTIL dependencies on BOM_INVENTORY_COMPONENTS

Line 573: from bom_explosions be, bom_inventory_components bic

569: CURSOR bom_cursor (bill_seq IN NUMBER,
570: exp_type IN VARCHAR2,
571: sort_ord IN VARCHAR2) IS
572: select count(top_bill_sequence_id) count
573: from bom_explosions be, bom_inventory_components bic
574: where top_bill_sequence_id = bill_seq
575: and explosion_type = exp_type
576: and sort_order = sort_ord
577: and be.component_sequence_id = bic.component_sequence_id

Line 1948: from bom_inventory_components bic,

1944: and nvl(bbom.alternate_bom_designator, 'NULL') = nvl(wfs.alternate_bom_designator, 'NULL');
1945:
1946: CURSOR nontxn_comp_cnt IS
1947: select count(component_item_id) comp_cnt
1948: from bom_inventory_components bic,
1949: mtl_system_items msi
1950: where bill_sequence_id = l_bill_seq_id
1951: and msi.inventory_item_id = bic.component_item_id
1952: and bic.effectivity_date < nvl(l_bom_rev_date,sysdate)