DBA Data[Home] [Help]

APPS.PO_PDOI_DISTRIBUTIONS_SV3 dependencies on WIP_REPETITIVE_SCHEDULES

Line 1032: -- Bug 3083961. If x_wip_repetitive_schedule_id is not null check in wip_repetitive_schedules.

1028: /* If the destination_type_code = 'SHOP FLOOR', then if */
1029: /* WIP_REPETITIVE_SCHEDULE_ID is not null then the record must be a */
1030: /* repetitive_schedule. If WIP_REPETITIVE_SCHEDULE_ID is NULL, then it */
1031: /* must be a discrete job */
1032: -- Bug 3083961. If x_wip_repetitive_schedule_id is not null check in wip_repetitive_schedules.
1033: -- else check in wip_discrete_jobs
1034:
1035: if x_wip_repetitive_schedule_id is not null then
1036: begin

Line 1038: FROM wip_repetitive_schedules wrs

1034:
1035: if x_wip_repetitive_schedule_id is not null then
1036: begin
1037: SELECT distinct 'Y' into x_valid
1038: FROM wip_repetitive_schedules wrs
1039: WHERE wrs.organization_id=x_destination_organization_id
1040: AND wrs.wip_entity_id = x_wip_entity_id
1041: AND wrs.repetitive_schedule_id =
1042: x_wip_repetitive_schedule_id