eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_JSI_DEFAULTER dependencies on BOM_CALENDAR_DATES

Line 991: from bom_calendar_dates bcd, mtl_parameters mp

987: wjsi_row.load_type = wip_constants.create_sched) then
988: --if no routing used work days and last unit comp date to determine fusd
989: select calendar_date
990: into wjsi_row.first_unit_start_date
991: from bom_calendar_dates bcd, mtl_parameters mp
992: where mp.organization_id = wjsi_row.organization_id
993: and bcd.exception_set_id = mp.calendar_exception_set_id
994: and bcd.calendar_code = mp.calendar_code
995: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1

Line 996: from bom_calendar_dates b2

992: where mp.organization_id = wjsi_row.organization_id
993: and bcd.exception_set_id = mp.calendar_exception_set_id
994: and bcd.calendar_code = mp.calendar_code
995: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1
996: from bom_calendar_dates b2
997: where b2.calendar_date = trunc(wjsi_row.last_unit_start_date)
998: and b2.calendar_code = mp.calendar_code
999: and b2.exception_set_id = bcd.exception_set_id)
1000: and (exists (select 1

Line 1058: from bom_calendar_dates bcd, mtl_parameters mp

1054: wjsi_row.load_type = wip_constants.create_sched) then
1055: --if no routing used work days and first unit comp date to determine fusd
1056: select calendar_date
1057: into wjsi_row.last_unit_start_date
1058: from bom_calendar_dates bcd, mtl_parameters mp
1059: where mp.organization_id = wjsi_row.organization_id
1060: and bcd.exception_set_id = mp.calendar_exception_set_id
1061: and bcd.calendar_code = mp.calendar_code
1062: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1

Line 1063: from bom_calendar_dates b2

1059: where mp.organization_id = wjsi_row.organization_id
1060: and bcd.exception_set_id = mp.calendar_exception_set_id
1061: and bcd.calendar_code = mp.calendar_code
1062: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1
1063: from bom_calendar_dates b2
1064: where b2.calendar_date = trunc(wjsi_row.first_unit_start_date)
1065: and b2.calendar_code = mp.calendar_code
1066: and b2.exception_set_id = bcd.exception_set_id)
1067: and (exists (select 1

Line 1097: from bom_calendar_dates bcd, mtl_parameters mp

1093: if(wjsi_row.first_unit_completion_date is null and
1094: wjsi_row.load_type = wip_constants.create_sched) then
1095: select calendar_date
1096: into wjsi_row.first_unit_completion_date
1097: from bom_calendar_dates bcd, mtl_parameters mp
1098: where mp.organization_id = wjsi_row.organization_id
1099: and bcd.exception_set_id = mp.calendar_exception_set_id
1100: and bcd.calendar_code = mp.calendar_code
1101: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1

Line 1102: from bom_calendar_dates b2

1098: where mp.organization_id = wjsi_row.organization_id
1099: and bcd.exception_set_id = mp.calendar_exception_set_id
1100: and bcd.calendar_code = mp.calendar_code
1101: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1
1102: from bom_calendar_dates b2
1103: where b2.calendar_date = trunc(wjsi_row.last_unit_completion_date)
1104: and b2.calendar_code = mp.calendar_code
1105: and b2.exception_set_id = bcd.exception_set_id)
1106: and (exists (select 1

Line 1135: from bom_calendar_dates bcd, mtl_parameters mp

1131: if(wjsi_row.last_unit_completion_date is null and
1132: wjsi_row.load_type = wip_constants.create_sched) then
1133: select calendar_date
1134: into wjsi_row.last_unit_completion_date
1135: from bom_calendar_dates bcd, mtl_parameters mp
1136: where mp.organization_id = wjsi_row.organization_id
1137: and bcd.exception_set_id = mp.calendar_exception_set_id
1138: and bcd.calendar_code = mp.calendar_code
1139: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1

Line 1140: from bom_calendar_dates b2

1136: where mp.organization_id = wjsi_row.organization_id
1137: and bcd.exception_set_id = mp.calendar_exception_set_id
1138: and bcd.calendar_code = mp.calendar_code
1139: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1
1140: from bom_calendar_dates b2
1141: where b2.calendar_date = trunc(wjsi_row.first_unit_completion_date)
1142: and b2.calendar_code = mp.calendar_code
1143: and b2.exception_set_id = bcd.exception_set_id)
1144: and (exists (select 1