DBA Data[Home] [Help]

APPS.PO_PDOI_DISTRIBUTIONS_SV3 dependencies on WIP_REPETITIVE_SCHEDULES

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

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

Line 1034: FROM wip_repetitive_schedules wrs

1030:
1031: if x_wip_repetitive_schedule_id is not null then
1032: begin
1033: SELECT distinct 'Y' into x_valid
1034: FROM wip_repetitive_schedules wrs
1035: WHERE wrs.organization_id=x_destination_organization_id
1036: AND wrs.wip_entity_id = x_wip_entity_id
1037: AND wrs.repetitive_schedule_id =
1038: x_wip_repetitive_schedule_id