APPS.MRP_AP_REL_PLAN_PUB dependencies on DUAL

Line 129: FROM DUAL;

125: -- PV_RESOURCE_TYPE,
126: PV_RES_PRIORITY,
127: PV_SIM_RES_SEQ,
128: PV_REL_REQUEST_DATE
129: FROM DUAL;
130:
131: SELECT wip_job_schedule_interface_s.nextval
132: INTO G_OPM_WIP_GROUP_ID
133: FROM DUAL;

Line 133: FROM DUAL;

129: FROM DUAL;
130:
131: SELECT wip_job_schedule_interface_s.nextval
132: INTO G_OPM_WIP_GROUP_ID
133: FROM DUAL;
134:
135: p_wip_group_id := G_WIP_GROUP_ID;
136: p_po_batch_number := G_PO_BATCH_NUMBER;
137:

Line 401: FROM DUAL;*/

397: null,
398: 1,
399: 1,
400: sysdate
401: FROM DUAL;*/
402:
403:
404: /* For Bug 3608361 -- we need not set start_date and completion date as null for unscheduled operations */
405: /*

Line 706: From Dual;

702: , lv_unschd_batch_id(l)
703: , LV_UNSCHD_MAX_ASSIGNED_UNITS(l)
704: , lv_unschd_parent_seq_num(l)
705: -- , lv_unschd_schedule_seq_num(l)
706: From Dual;
707: END LOOP;
708: END IF;
709:
710: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 790: From Dual;

786: null,
787: 1,
788: 1,
789: sysdate
790: From Dual;
791:
792: /* Bug 3344136
793: Insert INTO WSM_LOT_JOB_DTL_INTERFACE
794: ( last_update_date,

Line 836: From Dual;

832: null,
833: 2,
834: 1,
835: sysdate
836: From Dual;
837: */
838:
839: END LOOP;
840: END IF;

Line 1100: From Dual;

1096: , lv_unschd_batch_id(l)
1097: , LV_UNSCHD_MAX_ASSIGNED_UNITS(l)
1098: , lv_unschd_parent_seq_num(l)
1099: -- , lv_unschd_schedule_seq_num(l)
1100: From Dual;
1101: END LOOP;
1102: END IF;
1103:
1104: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 1214: From Dual;

1210: Null,
1211: 1,
1212: 1,
1213: sysdate
1214: From Dual;
1215:
1216: END LOOP;
1217: END IF;
1218:

Line 1296: From Dual;

1292: null,
1293: 1,
1294: 1,
1295: sysdate
1296: From Dual;
1297:
1298: /* Bug 3344136
1299: Insert INTO WSM_LOT_JOB_DTL_INTERFACE
1300: ( last_update_date,

Line 1342: From Dual;

1338: null,
1339: 2,
1340: 1,
1341: sysdate
1342: From Dual;
1343: */
1344:
1345: END LOOP;
1346: END IF;

Line 1437: From Dual;

1433: null,
1434: 1,
1435: 1,
1436: sysdate
1437: From Dual;
1438:
1439: END LOOP;
1440: END IF;
1441:

Line 1519: From Dual;

1515: null,
1516: 1,
1517: 1,
1518: sysdate
1519: From Dual;
1520: /*Bug 3344136
1521: Insert INTO WSM_LOT_JOB_DTL_INTERFACE
1522: ( last_update_date,
1523: last_updated_by,

Line 1564: From Dual;

1560: null,
1561: 2,
1562: 1,
1563: sysdate
1564: From Dual;
1565: */
1566: END LOOP;
1567: END IF;
1568:

Line 1659: From Dual;

1655: null,
1656: 1,
1657: 1,
1658: sysdate
1659: From Dual;
1660: END LOOP;
1661: END IF;
1662:
1663: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 3581: FROM DUAL;

3577: , lsud_batch_id(j)
3578: , lsud_maximum_assigned_units(j)
3579: , lsud_parent_seq_num(j)
3580: -- , lsud_schedule_seq_num(j)
3581: FROM DUAL;
3582:
3583:
3584: /*Delete the Alternate that we provided */
3585: delete from WIP_JOB_DTLS_INTERFACE

Line 3722: FROM DUAL;

3718: v_last_end,
3719: 2,
3720: 1,
3721: 2 --lv_scheduled_flag(j)
3722: FROM DUAL;
3723:
3724: End loop;
3725:
3726: FOR j IN 1..lun_res_req_count

Line 3982: FROM DUAL;

3978: v_last_end,
3979: 2,
3980: 1,
3981: 2 --lv_scheduled_flag(j)
3982: FROM DUAL;
3983:
3984: End;
3985:
3986:

Line 4153: FROM DUAL;

4149: 1,
4150: 2,
4151: 1,
4152: 1 --lv_scheduled_flag(j)
4153: FROM DUAL;
4154:
4155: delete from WIP_JOB_DTLS_INTERFACE
4156: WHERE ROWID= lv_res_alt_rowid(j);
4157: