APPS.CTO_UPDATE_BOM_RTG_PK dependencies on DUAL

Line 61: | Reference designators from all individual instances of the consolidated

57: |
58: |
59: | Modified : 04-09-2005 Sushant Sawant
60: | bug#3793286
61: | Reference designators from all individual instances of the consolidated
62: | component from the model bill should be copied to the consolidated component
63: | on the configuration bill.
64: | |
65: |

Line 1201: from dual;

1197: xBillId := 0;
1198: lStmtNum := 10;
1199: select bom_inventory_components_s.nextval
1200: into lConfigBillId
1201: from dual;
1202:
1203: WriteToLog('Creating Bill:: ' || lConfigBillId, 2);
1204:
1205: lStmtNum := 20;

Line 1746: from dual

1742: v_overlap_check := 0 ;
1743:
1744: begin
1745: select 1 into v_overlap_check
1746: from dual
1747: where exists
1748: ( select * from bom_inventory_comps_interface
1749: where bill_sequence_id = lConfigBillId
1750: group by component_item_id, assembly_item_id

Line 2384: from dual;

2380: end if;
2381:
2382: select bom_operational_routings_s.nextval
2383: into lCfgRtgId
2384: from dual;
2385:
2386: xTableName := 'BOM_OPERATIONAL_ROUTING';
2387: lStmtNum := 30;
2388:

Line 6689: from dual

6685: v_overlap_check := 0 ;
6686:
6687: begin
6688: select 1 into v_overlap_check
6689: from dual
6690: where exists
6691: ( select * from bom_inventory_comps_interface
6692: where bill_sequence_id = pConfigBillId
6693: group by component_item_id, assembly_item_id