APPS.BOMPASGB dependencies on BOM_INVENTORY_COMPONENTS

Line 409: bom_inventory_components_s.nextval)

405: loop
406: update bom_bill_of_mtls_interface ori
407: set transaction_id = mtl_system_items_interface_s.nextval,
408: bill_sequence_id = nvl(bill_sequence_id,
409: bom_inventory_components_s.nextval)
410: where transaction_id is null
411: and process_flag = 1
412: and rownum < 500;
413: EXIT when SQL%NOTFOUND;

Line 819: bom_inventory_components_s.nextval)

815: loop
816: update bom_inventory_comps_interface
817: set transaction_id = mtl_system_items_interface_s.nextval,
818: component_sequence_id = nvl(component_sequence_id,
819: bom_inventory_components_s.nextval)
820: where transaction_id is null
821: and process_flag = 1
822: and rownum < 500;
823: EXIT when SQL%NOTFOUND;

Line 1251: from bom_inventory_components

1247:
1248: BEGIN
1249: select component_sequence_id
1250: into cmp_seq_id
1251: from bom_inventory_components
1252: where bill_sequence_id = bill_seq_id
1253: and component_item_id = cmp_id
1254: and operation_seq_num = op_seq
1255: and to_char(effectivity_date,'YYYY/MM/DD HH24:MI') = eff_date;

Line 1635: from bom_inventory_components

1631:
1632: BEGIN
1633: select component_quantity
1634: into comp_qty
1635: from bom_inventory_components
1636: where component_sequence_id = comp_seq_id;
1637: return(0);
1638: EXCEPTION
1639: when NO_DATA_FOUND then