APPS.WIP_VALIDATEMLHEADER_PVT dependencies on BOM_CALENDAR_DATES

Line 2991: from bom_calendar_dates bcd,

2987: ((wjsi.first_unit_start_date is not null and wjsi.last_unit_completion_date is null) or
2988: (wjsi.first_unit_start_date is null and wjsi.last_unit_completion_date is not null))) */
2989: or (wjsi.first_unit_start_date is not null and
2990: not exists (select 1
2991: from bom_calendar_dates bcd,
2992: mtl_parameters mp
2993: where mp.organization_id = wjsi.organization_id
2994: and mp.calendar_code = bcd.calendar_code
2995: and mp.calendar_exception_set_id = bcd.exception_set_id

Line 2999: from bom_calendar_dates bcd,

2995: and mp.calendar_exception_set_id = bcd.exception_set_id
2996: and bcd.calendar_date = trunc(wjsi.first_unit_start_date)))
2997: or (wjsi.last_unit_completion_date is not null and
2998: not exists (select 1
2999: from bom_calendar_dates bcd,
3000: mtl_parameters mp
3001: where mp.organization_id = wjsi.organization_id
3002: and mp.calendar_code = bcd.calendar_code
3003: and mp.calendar_exception_set_id = bcd.exception_set_id

Line 4359: from bom_calendar_dates bcd,

4355: -- saugupta 25th-May-2006
4356: /*
4357: select calendar_date
4358: into wjsi_row.first_unit_start_date
4359: from bom_calendar_dates bcd,
4360: mtl_parameters mp
4361: where mp.organization_id = wjsi_row.organization_id
4362: and bcd.exception_set_id = mp.calendar_exception_set_id
4363: and bcd.calendar_code = mp.calendar_code

Line 4365: from bom_calendar_dates b2

4361: where mp.organization_id = wjsi_row.organization_id
4362: and bcd.exception_set_id = mp.calendar_exception_set_id
4363: and bcd.calendar_code = mp.calendar_code
4364: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1
4365: from bom_calendar_dates b2
4366: where b2.calendar_date = trunc(wjsi_row.last_unit_start_date)
4367: and b2.calendar_code = bcd.calendar_code
4368: and b2.exception_set_id = bcd.exception_set_id);
4369: */

Line 4372: FROM bom_calendar_dates bcd,

4368: and b2.exception_set_id = bcd.exception_set_id);
4369: */
4370: SELECT bcd.calendar_date
4371: INTO wjsi_row.first_unit_start_date
4372: FROM bom_calendar_dates bcd,
4373: mtl_parameters mp,
4374: bom_calendar_dates b2
4375: WHERE mp.organization_id = wjsi_row.organization_id
4376: and bcd.exception_set_id = mp.calendar_exception_set_id

Line 4374: bom_calendar_dates b2

4370: SELECT bcd.calendar_date
4371: INTO wjsi_row.first_unit_start_date
4372: FROM bom_calendar_dates bcd,
4373: mtl_parameters mp,
4374: bom_calendar_dates b2
4375: WHERE mp.organization_id = wjsi_row.organization_id
4376: and bcd.exception_set_id = mp.calendar_exception_set_id
4377: and bcd.calendar_code = mp.calendar_code
4378: and bcd.seq_num = b2.prior_seq_num - ceil(wjsi_row.processing_work_days)+1

Line 4390: from bom_calendar_dates bcd,

4386: -- saugupta 25th-May-2006
4387: /*
4388: select calendar_date
4389: into wjsi_row.last_unit_start_date
4390: from bom_calendar_dates bcd,
4391: mtl_parameters mp
4392: where mp.organization_id = wjsi_row.organization_id
4393: and bcd.exception_set_id = mp.calendar_exception_set_id
4394: and bcd.calendar_code = mp.calendar_code

Line 4396: from bom_calendar_dates b2

4392: where mp.organization_id = wjsi_row.organization_id
4393: and bcd.exception_set_id = mp.calendar_exception_set_id
4394: and bcd.calendar_code = mp.calendar_code
4395: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1
4396: from bom_calendar_dates b2
4397: where b2.calendar_date = trunc(wjsi_row.first_unit_start_date)
4398: and b2.calendar_code = bcd.calendar_code
4399: and b2.exception_set_id = bcd.exception_set_id);
4400: */

Line 4403: FROM bom_calendar_dates bcd,

4399: and b2.exception_set_id = bcd.exception_set_id);
4400: */
4401: SELECT bcd.calendar_date
4402: INTO wjsi_row.last_unit_start_date
4403: FROM bom_calendar_dates bcd,
4404: mtl_parameters mp,
4405: bom_calendar_dates b2
4406: WHERE mp.organization_id = wjsi_row.organization_id
4407: and bcd.exception_set_id = mp.calendar_exception_set_id

Line 4405: bom_calendar_dates b2

4401: SELECT bcd.calendar_date
4402: INTO wjsi_row.last_unit_start_date
4403: FROM bom_calendar_dates bcd,
4404: mtl_parameters mp,
4405: bom_calendar_dates b2
4406: WHERE mp.organization_id = wjsi_row.organization_id
4407: and bcd.exception_set_id = mp.calendar_exception_set_id
4408: and bcd.calendar_code = mp.calendar_code
4409: and bcd.seq_num = b2.prior_seq_num + ceil(wjsi_row.processing_work_days)-1

Line 4421: from bom_calendar_dates bcd,

4417: -- saugupta 25th-May-2006
4418: /*
4419: select calendar_date
4420: into wjsi_row.first_unit_completion_date
4421: from bom_calendar_dates bcd,
4422: mtl_parameters mp
4423: where mp.organization_id = wjsi_row.organization_id
4424: and bcd.exception_set_id = mp.calendar_exception_set_id
4425: and bcd.calendar_code = mp.calendar_code

Line 4427: from bom_calendar_dates b2

4423: where mp.organization_id = wjsi_row.organization_id
4424: and bcd.exception_set_id = mp.calendar_exception_set_id
4425: and bcd.calendar_code = mp.calendar_code
4426: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1
4427: from bom_calendar_dates b2
4428: where b2.calendar_date = trunc(wjsi_row.last_unit_completion_date)
4429: and b2.calendar_code = bcd.calendar_code
4430: and b2.exception_set_id = bcd.exception_set_id);
4431: */

Line 4435: FROM bom_calendar_dates bcd,

4431: */
4432:
4433: SELECT bcd.calendar_date
4434: INTO wjsi_row.first_unit_completion_date
4435: FROM bom_calendar_dates bcd,
4436: mtl_parameters mp,
4437: bom_calendar_dates b2
4438: WHERE mp.organization_id = wjsi_row.organization_id
4439: and bcd.exception_set_id = mp.calendar_exception_set_id

Line 4437: bom_calendar_dates b2

4433: SELECT bcd.calendar_date
4434: INTO wjsi_row.first_unit_completion_date
4435: FROM bom_calendar_dates bcd,
4436: mtl_parameters mp,
4437: bom_calendar_dates b2
4438: WHERE mp.organization_id = wjsi_row.organization_id
4439: and bcd.exception_set_id = mp.calendar_exception_set_id
4440: and bcd.calendar_code = mp.calendar_code
4441: and bcd.seq_num = b2.prior_seq_num - ceil(wjsi_row.processing_work_days)+1

Line 4453: from bom_calendar_dates bcd, mtl_parameters mp

4449: -- saugupta 25th-May-2006
4450: /*
4451: select calendar_date
4452: into wjsi_row.last_unit_completion_date
4453: from bom_calendar_dates bcd, mtl_parameters mp
4454: where mp.organization_id = wjsi_row.organization_id
4455: and bcd.exception_set_id = mp.calendar_exception_set_id
4456: and bcd.calendar_code = mp.calendar_code
4457: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1

Line 4458: from bom_calendar_dates b2

4454: where mp.organization_id = wjsi_row.organization_id
4455: and bcd.exception_set_id = mp.calendar_exception_set_id
4456: and bcd.calendar_code = mp.calendar_code
4457: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1
4458: from bom_calendar_dates b2
4459: where b2.calendar_date = trunc(wjsi_row.first_unit_completion_date)
4460: and b2.calendar_code = bcd.calendar_code
4461: and b2.exception_set_id = bcd.exception_set_id);
4462: */

Line 4466: FROM bom_calendar_dates bcd,

4462: */
4463:
4464: SELECT bcd.calendar_date
4465: INTO wjsi_row.last_unit_completion_date
4466: FROM bom_calendar_dates bcd,
4467: mtl_parameters mp,
4468: bom_calendar_dates b2
4469: WHERE mp.organization_id = wjsi_row.organization_id
4470: and bcd.exception_set_id = mp.calendar_exception_set_id

Line 4468: bom_calendar_dates b2

4464: SELECT bcd.calendar_date
4465: INTO wjsi_row.last_unit_completion_date
4466: FROM bom_calendar_dates bcd,
4467: mtl_parameters mp,
4468: bom_calendar_dates b2
4469: WHERE mp.organization_id = wjsi_row.organization_id
4470: and bcd.exception_set_id = mp.calendar_exception_set_id
4471: and bcd.calendar_code = mp.calendar_code
4472: and bcd.seq_num = b2.prior_seq_num + ceil(wjsi_row.processing_work_days)-1