APPS.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 258: FROM WIP_JOB_SCHEDULE_INTERFACE

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:

Line 567: FROM WIP_JOB_SCHEDULE_INTERFACE

563:
564: IF WIP_JOB_DETAILS.std_alone = 0 THEN
565:
566: SELECT scheduling_method INTO l_scheduling_method
567: FROM WIP_JOB_SCHEDULE_INTERFACE
568: WHERE group_id = p_group_id
569: AND wip_entity_id = p_wip_entity_id
570: AND organization_id = p_organization_id;
571:

Line 655: from wip_job_schedule_interface

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:

Line 1767: FROM wip_discrete_jobs wdj,wip_job_schedule_interface we

1763:
1764: -- Bug 3484856 - select the status of job and load type from wjsi
1765: SELECT wdj.start_quantity, greatest(wdj.start_quantity - wdj.quantity_completed - wdj.quantity_scrapped, 0), wdj.status_type, we.load_type
1766: INTO l_scheduled_quantity, l_open_quantity,l_status_type, l_load_type
1767: FROM wip_discrete_jobs wdj,wip_job_schedule_interface we
1768: WHERE wdj.wip_entity_id = p_wip_entity_id
1769: AND wdj.organization_id = p_organization_id
1770: AND wdj.wip_entity_id = we.wip_entity_id (+)
1771: AND wdj.organization_id = we.organization_id (+)

Line 2414: /* Fix for Bug#4398726. Added WIP_JOB_SCHEDULE_INTERFACE in following sql

2410: x_err_code out NOCOPY varchar2,
2411: x_err_msg out NOCOPY varchar2,
2412: x_return_status out NOCOPY varchar2) IS
2413:
2414: /* Fix for Bug#4398726. Added WIP_JOB_SCHEDULE_INTERFACE in following sql
2415: * statement to bypass validation for records populated by planning
2416: * This is done as per Planning request
2417: */
2418: cursor c_invalid_rows is

Line 2433: from wip_job_schedule_interface wjsi

2429: and (wjdi.first_unit_start_date is not null or
2430: wjdi.last_unit_completion_date is not null)
2431: /* Fix for Bug#6394857(FP of 6370245).
2432: and wjdi.group_id not in (select wjsi.group_id
2433: from wip_job_schedule_interface wjsi
2434: where wjsi.group_id = p_group_id
2435: and wjsi.source_code = 'MSC'
2436: )
2437: */

Line 2948: wip_job_schedule_interface wjsi,

2944: SELECT wjdi.serial_number_new serial_number,
2945: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
2946: nvl(we.organization_id, wjsi.organization_id) organization_id
2947: FROM wip_job_dtls_interface wjdi,
2948: wip_job_schedule_interface wjsi,
2949: wip_entities we
2950: WHERE wjdi.group_id = p_group_id
2951: AND wjsi.group_id = p_group_id
2952: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 3009: wip_job_schedule_interface wjsi,

3005: wjdi.serial_number_old,
3006: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
3007: nvl(we.organization_id, wjsi.organization_id) organization_id
3008: FROM wip_job_dtls_interface wjdi,
3009: wip_job_schedule_interface wjsi,
3010: wip_entities we
3011: WHERE wjdi.group_id = p_group_id
3012: AND wjsi.group_id = p_group_id
3013: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 3082: wip_job_schedule_interface wjsi,

3078: SELECT wjdi.serial_number_old serial_number,
3079: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
3080: nvl(we.organization_id, wjsi.organization_id) organization_id
3081: FROM wip_job_dtls_interface wjdi,
3082: wip_job_schedule_interface wjsi,
3083: wip_entities we
3084: WHERE wjdi.group_id = p_group_id
3085: AND wjsi.group_id = p_group_id
3086: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 3152: from wip_job_schedule_interface

3148: where organization_id = p_organization_id;
3149:
3150: select load_type
3151: into l_load_type
3152: from wip_job_schedule_interface
3153: where rowid = p_rowid;
3154:
3155: if(l_defaultSN = wip_constants.yes and
3156: l_load_type in ( wip_constants.create_job,wip_constants.create_ns_job)) /*Bug 13004022 - Added wip_constants.create_ns_job for auto association of serial numbers for non standard job also */