APPS.WIP_REQUIREMENT_VALIDATIONS dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 589: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi

585:
586: /* bug#2811687 : begin */
587: cursor c_supply_types_invalid_rows is
588: select wjdi.interface_id
589: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
590: where wjdi.group_id = p_group_id
591: and wjdi.process_phase = wip_constants.ml_validation
592: and wjdi.process_status in (wip_constants.running,
593: wip_constants.warning)

Line 610: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi

606: and wjdi.wip_supply_type <> wip_constants.push));
607:
608: cursor c_mrp_net_flag_invalid_rows is
609: select wjdi.interface_id
610: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
611: where wjdi.group_id = p_group_id
612: and wjdi.process_phase = wip_constants.ml_validation
613: and wjdi.process_status in (wip_constants.running,
614: wip_constants.warning)

Line 629: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi

625: and (wjdi.mrp_net_flag not in (wip_constants.yes, wip_constants.no));
626:
627: cursor c_auto_req_mat_invalid_rows is
628: select wjdi.interface_id
629: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
630: where wjdi.group_id = p_group_id
631: and wjdi.process_phase = wip_constants.ml_validation
632: and wjdi.process_status in (wip_constants.running,
633: wip_constants.warning)

Line 792: only if there is a parent record in wip_job_schedule_interface for the same job.

788: p_inventory_item_id_old in number,
789: p_inventory_item_id_new in number) IS
790:
791: /* This query is modified for bug 5216025. The join with WJSI is not required as the validation happens
792: only if there is a parent record in wip_job_schedule_interface for the same job.
793: */
794: cursor c_supply_types_invalid_rows is
795: select wjdi.interface_id
796: from wip_job_dtls_interface wjdi /*, wip_job_schedule_interface wjsi */

Line 796: from wip_job_dtls_interface wjdi /*, wip_job_schedule_interface wjsi */

792: only if there is a parent record in wip_job_schedule_interface for the same job.
793: */
794: cursor c_supply_types_invalid_rows is
795: select wjdi.interface_id
796: from wip_job_dtls_interface wjdi /*, wip_job_schedule_interface wjsi */
797: where wjdi.group_id = p_group_id
798: and wjdi.process_phase = wip_constants.ml_validation
799: and wjdi.process_status in (wip_constants.running,
800: wip_constants.warning)

Line 929: l_cmplocatorsgmt WIP_JOB_SCHEDULE_INTERFACE.COMPLETION_LOCATOR_SEGMENTS%TYPE ;

925: l_subLocCtl NUMBER;
926: l_project_id NUMBER;
927: l_task_id NUMBER;
928: l_success BOOLEAN;
929: l_cmplocatorsgmt WIP_JOB_SCHEDULE_INTERFACE.COMPLETION_LOCATOR_SEGMENTS%TYPE ;
930: l_locationcontrol NUMBER;
931: l_restriclocation NUMBER;
932: l_locexception EXCEPTION;
933: l_dummy2 VARCHAR2(1);