APPS.WSMPLBJI dependencies on DUAL

Line 618: from dual

614: start with to_op_seq_id = l_bon_seq_id1 and transition_type = 1
615: connect by to_op_seq_id = prior from_op_seq_id and transition_type = 1
616: union
617: select l_bon_seq_id1 "from_opseq_id", -1
618: from dual
619: ) order by 2 desc;
620:
621:
622: BEGIN

Line 628: from dual;

624:
625: if (p_explode_header_detail is null) or (p_explode_header_detail = 2) then
626: select wip_entities_s.nextval
627: into p_wip_entity_id
628: from dual;
629: end if;
630:
631: p_error_code := 0;
632: p_error_msg := '';

Line 1885: from sys.dual;

1881: --copy attachment from operations document attachment defined in the network routing form.
1882: if sql%rowcount > 0 then
1883: select p_job_seq_num
1884: into l_seq_incr
1885: from sys.dual;
1886:
1887: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
1888: X_FROM_ENTITY_NAME => 'BOM_OPERATION_SEQUENCES',
1889: X_FROM_PK1_VALUE => to_char(p_seq_id),

Line 2676: from dual;

2672: fnd_file.put_line(fnd_file.log, 'Number of Rows per worker = '||no_rows_per_worker);
2673:
2674: select wsm_lot_job_interface_s.NEXTVAL
2675: into l_group_id
2676: from dual;
2677:
2678: open c_pir;
2679: loop
2680:

Line 2716: from dual;

2712:
2713: if not c_pir%notfound then
2714: select wsm_lot_job_interface_s.NEXTVAL
2715: into l_group_id
2716: from dual;
2717: end if;
2718:
2719: end if;
2720:

Line 3244: from dual;

3240: -- ==============================================================================================
3241:
3242: select mtl_material_transactions_s.nextval
3243: into txn_header_id
3244: from dual;
3245:
3246: -- ==============================================================================================
3247: -- updating the group_id column of wlji with a number unique for this particular batch. This'll
3248: -- help when I select corresponding rows from wsli.

Line 3254: from dual;

3250: l_stmt_num := 78;
3251:
3252: select wsm_lot_job_interface_s.NEXTVAL
3253: into batch_group_id
3254: from dual;
3255:
3256: forall indx in v_wlji_header_id.first..v_wlji_header_id.last
3257: update wsm_lot_job_interface
3258: set group_id = batch_group_id

Line 4401: from dual ;

4397:
4398: -- Derive JOB_NAME.
4399: select FND_Profile.value('WIP_JOB_PREFIX') || wip_job_number_s.nextval
4400: into v_wlji_job_name(v_index)
4401: from dual ;
4402:
4403: else
4404:
4405: -- Be sure the provided JOB_NAME is not already in use.

Line 4460: /* commented out by BBK as per Hari to remove dual usage.

4456:
4457: else
4458: begin
4459:
4460: /* commented out by BBK as per Hari to remove dual usage.
4461: select 1 into l_dummy from dual where exists (
4462: select 1
4463: from wip_discrete_jobs
4464: where

Line 4461: select 1 into l_dummy from dual where exists (

4457: else
4458: begin
4459:
4460: /* commented out by BBK as per Hari to remove dual usage.
4461: select 1 into l_dummy from dual where exists (
4462: select 1
4463: from wip_discrete_jobs
4464: where
4465: wip_entity_id = v_wlji_wip_entity_id(v_index) and

Line 7299: /* commented out by BBK for DUAL usage reduction.

7295: WSMPLCVA.v_org(v_wlji_org(v_index)).MAX_STK_LOC_CNTRL := 1;
7296: end if;
7297:
7298: l_stmt_num := 1120;
7299: /* commented out by BBK for DUAL usage reduction.
7300: select mtl_material_transactions_s.nextval
7301: into txn_tmp_header_id
7302: from dual;
7303: */

Line 7302: from dual;

7298: l_stmt_num := 1120;
7299: /* commented out by BBK for DUAL usage reduction.
7300: select mtl_material_transactions_s.nextval
7301: into txn_tmp_header_id
7302: from dual;
7303: */
7304:
7305: l_stmt_num := 1140;
7306: Begin -- material transaction