DBA Data[Home] [Help]

APPS.CTO_CONFIG_BOM_PK dependencies on DUAL

Line 422: from dual;

418: else
419:
420: select bom_inventory_components_s.nextval
421: into lConfigBillId
422: from dual;
423:
424: end if ;
425:
426: xBillId := lConfigBillId;

Line 1184: from dual

1180: v_overlap_check := 0 ;
1181:
1182: begin
1183: select 1 into v_overlap_check
1184: from dual
1185: where exists
1186: ( select * from bom_inventory_comps_interface
1187: where bill_sequence_id = lConfigBillId
1188: group by component_item_id, assembly_item_id

Line 5062: from dual

5058: v_overlap_check := 0 ;
5059:
5060: begin
5061: select 1 into v_overlap_check
5062: from dual
5063: where exists
5064: ( select * from bom_inventory_comps_interface
5065: where bill_sequence_id = pConfigBillId
5066: group by component_item_id, assembly_item_id