APPS.PO_VAL_DISTRIBUTIONS2 dependencies on WIP_REPETITIVE_SCHEDULES

Line 810: -- Validate against wip_repetitive_schedules/

806: -- If destination_type_code is SHOP FLOOR,
807: -- If wip_entity_id is null,
808: -- ERR: 'PO_PDOI_COLUMN_NOT_NULL'
809: -- Else
810: -- Validate against wip_repetitive_schedules/
811: -- wip_discrete_jobs depending on the value of
812: -- wip_repetitive_schedule_id. (If the
813: -- destination_type_code = 'SHOP FLOOR', then if
814: -- WIP_REPETITIVE_SCHEDULE_ID is not null then the

Line 890: FROM wip_repetitive_schedules wrs

886: AND p_wip_entity_id_tbl(i) IS NOT NULL
887: AND p_wip_rep_schedule_id_tbl(i) IS NOT NULL
888: AND NOT EXISTS(
889: SELECT 1
890: FROM wip_repetitive_schedules wrs
891: WHERE wrs.organization_id = p_destination_org_id_tbl(i)
892: AND wrs.wip_entity_id = p_wip_entity_id_tbl(i)
893: AND wrs.repetitive_schedule_id = p_wip_rep_schedule_id_tbl(i)
894: AND wrs.status_type IN(3, 4, 6));