DBA Data[Home] [Help]

APPS.WIP_RESOURCE_VALIDATIONS dependencies on PO_RELEASES_ALL

Line 354: FROM PO_RELEASES_ALL PR,

350: and wjdi.resource_id_old = p_resource_id_old
351: -- Bug 4321480 - Modified the exists clause to exclude Cancelled PO/POR.
352: and (exists
353: ( SELECT 'PO/REQ Linked'
354: FROM PO_RELEASES_ALL PR,
355: PO_HEADERS_ALL PH,
356: PO_DISTRIBUTIONS_ALL PD,
357: PO_LINE_LOCATIONS_ALL PLL
358: WHERE pd.po_line_id IS NOT NULL

Line 470: FROM PO_RELEASES_ALL PR,

466: and wjdi.resource_id_old = p_resource_id_old
467: -- Bug 4321480 - Modified the exists clause to exclude Cancelled PO/POR.
468: and (exists
469: ( SELECT 'PO/REQ Linked'
470: FROM PO_RELEASES_ALL PR,
471: PO_HEADERS_ALL PH,
472: PO_DISTRIBUTIONS_ALL PD,
473: PO_LINE_LOCATIONS_ALL PLL
474: WHERE pd.po_line_id IS NOT NULL