DBA Data[Home] [Help]

APPS.MRP_KANBAN_PLAN_PK dependencies on DUAL

Line 802: DUAL;

798: fnd_global.user_id,
799: sysdate,
800: fnd_global.user_id
801: FROM
802: DUAL;
803:
804: END IF;
805: END IF;--demand > 0
806: END LOOP;

Line 1274: DUAL;

1270: fnd_global.user_id,
1271: sysdate,
1272: fnd_global.user_id
1273: FROM
1274: DUAL;
1275:
1276: END IF;
1277:
1278: ELSIF l_rate_end_date IS NOT NULL THEN

Line 1828: DUAL;

1824: fnd_global.user_id,
1825: sysdate,
1826: fnd_global.user_id
1827: FROM
1828: DUAL;
1829:
1830: END IF;
1831: END LOOP;-- end of my cursor
1832: IF parent_schedule_entries%ISOPEN THEN

Line 2331: DUAL;

2327: fnd_global.user_id,
2328: sysdate,
2329: fnd_global.user_id
2330: FROM
2331: DUAL;
2332:
2333: END IF;
2334: END LOOP;-- end of my cursor
2335: IF parent_schedule_entries%ISOPEN THEN

Line 2465: select g_kanban_info_rec.input_designator from dual

2461: )
2462: )
2463: */ --bug 5237549
2464: AND FORECAST_DESIGNATOR in (
2465: select g_kanban_info_rec.input_designator from dual
2466: union all
2467: SELECT FORECAST_DESIGNATOR
2468: FROM MRP_FORECAST_DESIGNATORS
2469: WHERE FORECAST_SET = g_kanban_info_rec.input_designator )

Line 3521: select g_kanban_info_rec.input_designator from dual

3517: )
3518: )
3519: */ --bug 5237549
3520: AND FORECAST_DESIGNATOR in (
3521: select g_kanban_info_rec.input_designator from dual
3522: union all
3523: SELECT FORECAST_DESIGNATOR
3524: FROM MRP_FORECAST_DESIGNATORS
3525: WHERE FORECAST_SET = g_kanban_info_rec.input_designator )

Line 4199: FROM dual;

4195: l_pull_sequence_rec.last_update_date,
4196: l_pull_sequence_rec.last_updated_by,
4197: l_pull_sequence_rec.creation_date,
4198: l_pull_sequence_rec.created_by
4199: FROM dual;
4200:
4201: l_pull_sequence_rec.organization_id := g_kanban_info_rec.organization_id;
4202: l_pull_sequence_rec.kanban_plan_id := g_kanban_info_rec.kanban_plan_id;
4203: l_pull_sequence_rec.inventory_item_id := l_item_id;