APPS.BOMPASGB dependencies on MTL_SYSTEM_ITEMS

Line 206: set transaction_id = mtl_system_items_interface_s.nextval

202: ** assign transaction ids to all rows first
203: */
204: loop
205: update mtl_item_revisions_interface
206: set transaction_id = mtl_system_items_interface_s.nextval
207: where transaction_id is null
208: and process_flag = 1
209: and rownum < 500;
210: EXIT when SQL%NOTFOUND;

Line 407: set transaction_id = mtl_system_items_interface_s.nextval,

403: */
404: stmt_num := 1;
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

Line 591: mtl_system_items_interface_s.nextval,

587: nvl(c1rec.CB, user_id),
588: nvl(c1rec.LUL, user_id),
589: sysdate,
590: sysdate,
591: mtl_system_items_interface_s.nextval,
592: 2,
593: req_id,
594: prog_appid,
595: prog_id,

Line 817: set transaction_id = mtl_system_items_interface_s.nextval,

813: ** assign transaction ids to all rows first
814: */
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

Line 1036: from mtl_system_items

1032: BEGIN
1033: BEGIN
1034: select bom_item_type
1035: into c1rec.BIT
1036: from mtl_system_items
1037: where organization_id = c1rec.OI
1038: and inventory_item_id = c1rec.CII;
1039: goto default_op_seq;
1040: EXCEPTION

Line 1776: set transaction_id = mtl_system_items_interface_s.nextval

1772: ** assign transaction ids for every row
1773: */
1774: loop
1775: update bom_ref_desgs_interface
1776: set transaction_id = mtl_system_items_interface_s.nextval
1777: where transaction_id is null
1778: and process_flag = 1
1779: and rownum < 500;
1780: EXIT when SQL%NOTFOUND;

Line 2046: select mtl_system_items_interface_s.nextval

2042:
2043: while continue_loop loop
2044: for c3rec in c3 loop
2045: commit_cnt := commit_cnt + 1;
2046: select mtl_system_items_interface_s.nextval
2047: into dummy_txn
2048: from sys.dual;
2049:
2050: update bom_ref_desgs_interface

Line 2211: set transaction_id = mtl_system_items_interface_s.nextval

2207: ** assign transaction ids for every row
2208: */
2209: loop
2210: update bom_sub_comps_interface
2211: set transaction_id = mtl_system_items_interface_s.nextval
2212: where transaction_id is null
2213: and process_flag = 1
2214: and rownum < 500;
2215: EXIT when SQL%NOTFOUND;

Line 2533: select mtl_system_items_interface_s.nextval

2529:
2530: while continue_loop loop
2531: for c3rec in c3 loop
2532: commit_cnt := commit_cnt + 1;
2533: select mtl_system_items_interface_s.nextval
2534: into dummy_txn
2535: from sys.dual;
2536:
2537: update bom_sub_comps_interface