DBA Data[Home] [Help]

APPS.CTO_CONFIG_BOM_PK dependencies on DUAL

Line 420: from dual;

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

Line 1158: from dual

1154: v_overlap_check := 0 ;
1155:
1156: begin
1157: select 1 into v_overlap_check
1158: from dual
1159: where exists
1160: ( select * from bom_inventory_comps_interface
1161: where bill_sequence_id = lConfigBillId
1162: group by component_item_id, assembly_item_id

Line 4743: from dual

4739: v_overlap_check := 0 ;
4740:
4741: begin
4742: select 1 into v_overlap_check
4743: from dual
4744: where exists
4745: ( select * from bom_inventory_comps_interface
4746: where bill_sequence_id = pConfigBillId
4747: group by component_item_id, assembly_item_id