DBA Data[Home] [Help]

APPS.WIP_RESOURCE_VALIDATIONS dependencies on PO_HEADERS_ALL

Line 355: PO_HEADERS_ALL PH,

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
359: AND pd.line_location_id IS NOT NULL

Line 471: PO_HEADERS_ALL PH,

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
475: AND pd.line_location_id IS NOT NULL