APPS.WIP_JSI_DEFAULTER dependencies on MTL_PARAMETERS

Line 235: from mtl_parameters

231: if(wjsi_row.organization_code is not null) then
232: if(wjsi_row.organization_id is null) then
233: select organization_id
234: into wjsi_row.organization_id
235: from mtl_parameters
236: where organization_code = wjsi_row.organization_code;
237: else
238: WIP_JSI_Utils.record_ignored_column_warning('ORGANIZATION_CODE');
239: end if;

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 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 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 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 1729: from mtl_parameters

1725:
1726: elsif (wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job)) then
1727: select wms_enabled_flag
1728: into l_wms_enabled_flag
1729: from mtl_parameters
1730: where organization_id = wjsi_row.organization_id;
1731:
1732: if (upper(l_wms_enabled_flag) = 'Y') then
1733: wjsi_row.material_issue_by_mo := 'N';