[Home] [Help]
254:
255: IF WIP_JOB_DETAILS.std_alone = 0 THEN
256:
257: SELECT scheduling_method INTO l_scheduling_method
258: FROM WIP_JOB_SCHEDULE_INTERFACE
259: WHERE group_id = p_group_id
260: AND wip_entity_id = p_wip_entity_id
261: AND organization_id = p_organization_id;
262:
557:
558: IF WIP_JOB_DETAILS.std_alone = 0 THEN
559:
560: SELECT scheduling_method INTO l_scheduling_method
561: FROM WIP_JOB_SCHEDULE_INTERFACE
562: WHERE group_id = p_group_id
563: AND wip_entity_id = p_wip_entity_id
564: AND organization_id = p_organization_id;
565:
651: select source_code,
652: scheduling_method
653: into l_source_code,
654: l_scheduling_method
655: from wip_job_schedule_interface
656: where group_id = p_group_id
657: and wip_entity_id = p_wip_entity_id
658: and organization_id = p_organization_id ;
659:
1737:
1738: -- Bug 3484856 - select the status of job and load type from wjsi
1739: SELECT wdj.start_quantity, greatest(wdj.start_quantity - wdj.quantity_completed - wdj.quantity_scrapped, 0), wdj.status_type, we.load_type
1740: INTO l_scheduled_quantity, l_open_quantity,l_status_type, l_load_type
1741: FROM wip_discrete_jobs wdj,wip_job_schedule_interface we
1742: WHERE wdj.wip_entity_id = p_wip_entity_id
1743: AND wdj.organization_id = p_organization_id
1744: AND wdj.wip_entity_id = we.wip_entity_id (+)
1745: AND wdj.organization_id = we.organization_id (+)
2285: x_err_code out NOCOPY varchar2,
2286: x_err_msg out NOCOPY varchar2,
2287: x_return_status out NOCOPY varchar2) IS
2288:
2289: /* Fix for Bug#4398726. Added WIP_JOB_SCHEDULE_INTERFACE in following sql
2290: * statement to bypass validation for records populated by planning
2291: * This is done as per Planning request
2292: */
2293: cursor c_invalid_rows is
2304: and (wjdi.first_unit_start_date is not null or
2305: wjdi.last_unit_completion_date is not null)
2306: /* Fix for Bug#6394857(FP of 6370245).
2307: and wjdi.group_id not in (select wjsi.group_id
2308: from wip_job_schedule_interface wjsi
2309: where wjsi.group_id = p_group_id
2310: and wjsi.source_code = 'MSC'
2311: )
2312: */
2818: SELECT wjdi.serial_number_new serial_number,
2819: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
2820: nvl(we.organization_id, wjsi.organization_id) organization_id
2821: FROM wip_job_dtls_interface wjdi,
2822: wip_job_schedule_interface wjsi,
2823: wip_entities we
2824: WHERE wjdi.group_id = p_group_id
2825: AND wjsi.group_id = p_group_id
2826: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
2879: wjdi.serial_number_old,
2880: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
2881: nvl(we.organization_id, wjsi.organization_id) organization_id
2882: FROM wip_job_dtls_interface wjdi,
2883: wip_job_schedule_interface wjsi,
2884: wip_entities we
2885: WHERE wjdi.group_id = p_group_id
2886: AND wjsi.group_id = p_group_id
2887: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
2952: SELECT wjdi.serial_number_old serial_number,
2953: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
2954: nvl(we.organization_id, wjsi.organization_id) organization_id
2955: FROM wip_job_dtls_interface wjdi,
2956: wip_job_schedule_interface wjsi,
2957: wip_entities we
2958: WHERE wjdi.group_id = p_group_id
2959: AND wjsi.group_id = p_group_id
2960: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
3022: where organization_id = p_organization_id;
3023:
3024: select load_type
3025: into l_load_type
3026: from wip_job_schedule_interface
3027: where rowid = p_rowid;
3028:
3029: if(l_defaultSN = wip_constants.yes and
3030: l_load_type = wip_constants.create_job) then