APPS.BOMPASGB dependencies on DUAL

Line 394: from dual where exists ( select 1

390: )
391: and rownum < 500;
392:
393: cursor c3 is select 1
394: from dual where exists ( select 1
395: from MTL_ITEM_REVISIONS_INTERFACE
396: where inventory_item_id = assembly_id
397: and organization_id = assembly_org_id
398: and revision = item_rev);

Line 2048: from sys.dual;

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
2051: set transaction_id = dummy_txn,
2052: process_flag = 2

Line 2535: from sys.dual;

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
2538: set transaction_id = dummy_txn,
2539: process_flag = 2