APPS.WIP_REQUIREMENT_VALIDATIONS dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 591: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi

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

Line 612: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi

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

Line 631: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi

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

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

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

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

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