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 1142: from dual;

1138: xBillId := 0;
1139: lStmtNum := 10;
1140: select bom_inventory_components_s.nextval
1141: into lConfigBillId
1142: from dual;
1143:
1144: WriteToLog('Creating Bill:: ' || lConfigBillId, 2);
1145:
1146: lStmtNum := 20;

Line 1687: from dual

1683: v_overlap_check := 0 ;
1684:
1685: begin
1686: select 1 into v_overlap_check
1687: from dual
1688: where exists
1689: ( select * from bom_inventory_comps_interface
1690: where bill_sequence_id = lConfigBillId
1691: group by component_item_id, assembly_item_id

Line 2295: from dual;

2291: end if;
2292:
2293: select bom_operational_routings_s.nextval
2294: into lCfgRtgId
2295: from dual;
2296:
2297: xTableName := 'BOM_OPERATIONAL_ROUTING';
2298: lStmtNum := 30;
2299:

Line 6477: from dual

6473: v_overlap_check := 0 ;
6474:
6475: begin
6476: select 1 into v_overlap_check
6477: from dual
6478: where exists
6479: ( select * from bom_inventory_comps_interface
6480: where bill_sequence_id = pConfigBillId
6481: group by component_item_id, assembly_item_id