APPS.PO_VAL_DISTRIBUTIONS2 dependencies on WIP_REPETITIVE_SCHEDULES

Line 798: -- Validate against wip_repetitive_schedules/

794: -- If destination_type_code is SHOP FLOOR,
795: -- If wip_entity_id is null,
796: -- ERR: 'PO_PDOI_COLUMN_NOT_NULL'
797: -- Else
798: -- Validate against wip_repetitive_schedules/
799: -- wip_discrete_jobs depending on the value of
800: -- wip_repetitive_schedule_id. (If the
801: -- destination_type_code = 'SHOP FLOOR', then if
802: -- WIP_REPETITIVE_SCHEDULE_ID is not null then the

Line 878: FROM wip_repetitive_schedules wrs

874: AND p_wip_entity_id_tbl(i) IS NOT NULL
875: AND p_wip_rep_schedule_id_tbl(i) IS NOT NULL
876: AND NOT EXISTS(
877: SELECT 1
878: FROM wip_repetitive_schedules wrs
879: WHERE wrs.organization_id = p_destination_org_id_tbl(i)
880: AND wrs.wip_entity_id = p_wip_entity_id_tbl(i)
881: AND wrs.repetitive_schedule_id = p_wip_rep_schedule_id_tbl(i)
882: AND wrs.status_type IN(3, 4, 6));