APPS.WIP_VALIDATEMLHEADER_PVT dependencies on BOM_CALENDAR_DATES

Line 2962: from bom_calendar_dates bcd,

2958: ((wjsi.first_unit_start_date is not null and wjsi.last_unit_completion_date is null) or
2959: (wjsi.first_unit_start_date is null and wjsi.last_unit_completion_date is not null)))
2960: or (wjsi.first_unit_start_date is not null and
2961: not exists (select 1
2962: from bom_calendar_dates bcd,
2963: mtl_parameters mp
2964: where mp.organization_id = wjsi.organization_id
2965: and mp.calendar_code = bcd.calendar_code
2966: and mp.calendar_exception_set_id = bcd.exception_set_id

Line 2970: from bom_calendar_dates bcd,

2966: and mp.calendar_exception_set_id = bcd.exception_set_id
2967: and bcd.calendar_date = trunc(wjsi.first_unit_start_date)))
2968: or (wjsi.last_unit_completion_date is not null and
2969: not exists (select 1
2970: from bom_calendar_dates bcd,
2971: mtl_parameters mp
2972: where mp.organization_id = wjsi.organization_id
2973: and mp.calendar_code = bcd.calendar_code
2974: and mp.calendar_exception_set_id = bcd.exception_set_id

Line 4230: from bom_calendar_dates bcd,

4226: -- saugupta 25th-May-2006
4227: /*
4228: select calendar_date
4229: into wjsi_row.first_unit_start_date
4230: from bom_calendar_dates bcd,
4231: mtl_parameters mp
4232: where mp.organization_id = wjsi_row.organization_id
4233: and bcd.exception_set_id = mp.calendar_exception_set_id
4234: and bcd.calendar_code = mp.calendar_code

Line 4236: from bom_calendar_dates b2

4232: where mp.organization_id = wjsi_row.organization_id
4233: and bcd.exception_set_id = mp.calendar_exception_set_id
4234: and bcd.calendar_code = mp.calendar_code
4235: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1
4236: from bom_calendar_dates b2
4237: where b2.calendar_date = trunc(wjsi_row.last_unit_start_date)
4238: and b2.calendar_code = bcd.calendar_code
4239: and b2.exception_set_id = bcd.exception_set_id);
4240: */

Line 4243: FROM bom_calendar_dates bcd,

4239: and b2.exception_set_id = bcd.exception_set_id);
4240: */
4241: SELECT bcd.calendar_date
4242: INTO wjsi_row.first_unit_start_date
4243: FROM bom_calendar_dates bcd,
4244: mtl_parameters mp,
4245: bom_calendar_dates b2
4246: WHERE mp.organization_id = wjsi_row.organization_id
4247: and bcd.exception_set_id = mp.calendar_exception_set_id

Line 4245: bom_calendar_dates b2

4241: SELECT bcd.calendar_date
4242: INTO wjsi_row.first_unit_start_date
4243: FROM bom_calendar_dates bcd,
4244: mtl_parameters mp,
4245: bom_calendar_dates b2
4246: WHERE mp.organization_id = wjsi_row.organization_id
4247: and bcd.exception_set_id = mp.calendar_exception_set_id
4248: and bcd.calendar_code = mp.calendar_code
4249: and bcd.seq_num = b2.prior_seq_num - ceil(wjsi_row.processing_work_days)+1

Line 4261: from bom_calendar_dates bcd,

4257: -- saugupta 25th-May-2006
4258: /*
4259: select calendar_date
4260: into wjsi_row.last_unit_start_date
4261: from bom_calendar_dates bcd,
4262: mtl_parameters mp
4263: where mp.organization_id = wjsi_row.organization_id
4264: and bcd.exception_set_id = mp.calendar_exception_set_id
4265: and bcd.calendar_code = mp.calendar_code

Line 4267: from bom_calendar_dates b2

4263: where mp.organization_id = wjsi_row.organization_id
4264: and bcd.exception_set_id = mp.calendar_exception_set_id
4265: and bcd.calendar_code = mp.calendar_code
4266: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1
4267: from bom_calendar_dates b2
4268: where b2.calendar_date = trunc(wjsi_row.first_unit_start_date)
4269: and b2.calendar_code = bcd.calendar_code
4270: and b2.exception_set_id = bcd.exception_set_id);
4271: */

Line 4274: FROM bom_calendar_dates bcd,

4270: and b2.exception_set_id = bcd.exception_set_id);
4271: */
4272: SELECT bcd.calendar_date
4273: INTO wjsi_row.last_unit_start_date
4274: FROM bom_calendar_dates bcd,
4275: mtl_parameters mp,
4276: bom_calendar_dates b2
4277: WHERE mp.organization_id = wjsi_row.organization_id
4278: and bcd.exception_set_id = mp.calendar_exception_set_id

Line 4276: bom_calendar_dates b2

4272: SELECT bcd.calendar_date
4273: INTO wjsi_row.last_unit_start_date
4274: FROM bom_calendar_dates bcd,
4275: mtl_parameters mp,
4276: bom_calendar_dates b2
4277: WHERE mp.organization_id = wjsi_row.organization_id
4278: and bcd.exception_set_id = mp.calendar_exception_set_id
4279: and bcd.calendar_code = mp.calendar_code
4280: and bcd.seq_num = b2.prior_seq_num + ceil(wjsi_row.processing_work_days)-1

Line 4292: from bom_calendar_dates bcd,

4288: -- saugupta 25th-May-2006
4289: /*
4290: select calendar_date
4291: into wjsi_row.first_unit_completion_date
4292: from bom_calendar_dates bcd,
4293: mtl_parameters mp
4294: where mp.organization_id = wjsi_row.organization_id
4295: and bcd.exception_set_id = mp.calendar_exception_set_id
4296: and bcd.calendar_code = mp.calendar_code

Line 4298: from bom_calendar_dates b2

4294: where mp.organization_id = wjsi_row.organization_id
4295: and bcd.exception_set_id = mp.calendar_exception_set_id
4296: and bcd.calendar_code = mp.calendar_code
4297: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1
4298: from bom_calendar_dates b2
4299: where b2.calendar_date = trunc(wjsi_row.last_unit_completion_date)
4300: and b2.calendar_code = bcd.calendar_code
4301: and b2.exception_set_id = bcd.exception_set_id);
4302: */

Line 4306: FROM bom_calendar_dates bcd,

4302: */
4303:
4304: SELECT bcd.calendar_date
4305: INTO wjsi_row.first_unit_completion_date
4306: FROM bom_calendar_dates bcd,
4307: mtl_parameters mp,
4308: bom_calendar_dates b2
4309: WHERE mp.organization_id = wjsi_row.organization_id
4310: and bcd.exception_set_id = mp.calendar_exception_set_id

Line 4308: bom_calendar_dates b2

4304: SELECT bcd.calendar_date
4305: INTO wjsi_row.first_unit_completion_date
4306: FROM bom_calendar_dates bcd,
4307: mtl_parameters mp,
4308: bom_calendar_dates b2
4309: WHERE mp.organization_id = wjsi_row.organization_id
4310: and bcd.exception_set_id = mp.calendar_exception_set_id
4311: and bcd.calendar_code = mp.calendar_code
4312: and bcd.seq_num = b2.prior_seq_num - ceil(wjsi_row.processing_work_days)+1

Line 4324: from bom_calendar_dates bcd, mtl_parameters mp

4320: -- saugupta 25th-May-2006
4321: /*
4322: select calendar_date
4323: into wjsi_row.last_unit_completion_date
4324: from bom_calendar_dates bcd, mtl_parameters mp
4325: where mp.organization_id = wjsi_row.organization_id
4326: and bcd.exception_set_id = mp.calendar_exception_set_id
4327: and bcd.calendar_code = mp.calendar_code
4328: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1

Line 4329: from bom_calendar_dates b2

4325: where mp.organization_id = wjsi_row.organization_id
4326: and bcd.exception_set_id = mp.calendar_exception_set_id
4327: and bcd.calendar_code = mp.calendar_code
4328: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1
4329: from bom_calendar_dates b2
4330: where b2.calendar_date = trunc(wjsi_row.first_unit_completion_date)
4331: and b2.calendar_code = bcd.calendar_code
4332: and b2.exception_set_id = bcd.exception_set_id);
4333: */

Line 4337: FROM bom_calendar_dates bcd,

4333: */
4334:
4335: SELECT bcd.calendar_date
4336: INTO wjsi_row.last_unit_completion_date
4337: FROM bom_calendar_dates bcd,
4338: mtl_parameters mp,
4339: bom_calendar_dates b2
4340: WHERE mp.organization_id = wjsi_row.organization_id
4341: and bcd.exception_set_id = mp.calendar_exception_set_id

Line 4339: bom_calendar_dates b2

4335: SELECT bcd.calendar_date
4336: INTO wjsi_row.last_unit_completion_date
4337: FROM bom_calendar_dates bcd,
4338: mtl_parameters mp,
4339: bom_calendar_dates b2
4340: WHERE mp.organization_id = wjsi_row.organization_id
4341: and bcd.exception_set_id = mp.calendar_exception_set_id
4342: and bcd.calendar_code = mp.calendar_code
4343: and bcd.seq_num = b2.prior_seq_num + ceil(wjsi_row.processing_work_days)-1