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

2678: fnd_file.put_line(fnd_file.log, 'Number of Rows per worker = '||no_rows_per_worker);
2679:
2680: select wsm_lot_job_interface_s.NEXTVAL
2681: into l_group_id
2682: from dual;
2683:
2684: open c_pir;
2685: loop
2686:

Line 2722: from dual;

2718:
2719: if not c_pir%notfound then
2720: select wsm_lot_job_interface_s.NEXTVAL
2721: into l_group_id
2722: from dual;
2723: end if;
2724:
2725: end if;
2726:

Line 3250: from dual;

3246: -- ==============================================================================================
3247:
3248: select mtl_material_transactions_s.nextval
3249: into txn_header_id
3250: from dual;
3251:
3252: -- ==============================================================================================
3253: -- updating the group_id column of wlji with a number unique for this particular batch. This'll
3254: -- help when I select corresponding rows from wsli.

Line 3260: from dual;

3256: l_stmt_num := 78;
3257:
3258: select wsm_lot_job_interface_s.NEXTVAL
3259: into batch_group_id
3260: from dual;
3261:
3262: forall indx in v_wlji_header_id.first..v_wlji_header_id.last
3263: update wsm_lot_job_interface
3264: set group_id = batch_group_id

Line 4407: from dual ;

4403:
4404: -- Derive JOB_NAME.
4405: select FND_Profile.value('WIP_JOB_PREFIX') || wip_job_number_s.nextval
4406: into v_wlji_job_name(v_index)
4407: from dual ;
4408:
4409: else
4410:
4411: -- Be sure the provided JOB_NAME is not already in use.

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

4462:
4463: else
4464: begin
4465:
4466: /* commented out by BBK as per Hari to remove dual usage.
4467: select 1 into l_dummy from dual where exists (
4468: select 1
4469: from wip_discrete_jobs
4470: where

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

4463: else
4464: begin
4465:
4466: /* commented out by BBK as per Hari to remove dual usage.
4467: select 1 into l_dummy from dual where exists (
4468: select 1
4469: from wip_discrete_jobs
4470: where
4471: wip_entity_id = v_wlji_wip_entity_id(v_index) and

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

7301: WSMPLCVA.v_org(v_wlji_org(v_index)).MAX_STK_LOC_CNTRL := 1;
7302: end if;
7303:
7304: l_stmt_num := 1120;
7305: /* commented out by BBK for DUAL usage reduction.
7306: select mtl_material_transactions_s.nextval
7307: into txn_tmp_header_id
7308: from dual;
7309: */

Line 7308: from dual;

7304: l_stmt_num := 1120;
7305: /* commented out by BBK for DUAL usage reduction.
7306: select mtl_material_transactions_s.nextval
7307: into txn_tmp_header_id
7308: from dual;
7309: */
7310:
7311: l_stmt_num := 1140;
7312: Begin -- material transaction