APPS.WIP_OSP dependencies on PO_RELEASES_ALL

Line 904: FROM PO_RELEASES_ALL PR,

900: */
901:
902: CURSOR disc_check_po_req_cur IS
903: SELECT 'PO/REQ Linked'
904: FROM PO_RELEASES_ALL PR,
905: PO_HEADERS_ALL PH,
906: PO_DISTRIBUTIONS_ALL PD,
907: PO_LINE_LOCATIONS_ALL PLL /* Added as part of Bug2308832 */ /* Fixed bug 3115844 */
908: WHERE pd.po_line_id IS NOT NULL

Line 948: FROM PO_RELEASES_ALL PR,

944:
945:
946: CURSOR rep_check_po_req_cur IS
947: SELECT 'PO/REQ Linked'
948: FROM PO_RELEASES_ALL PR,
949: PO_HEADERS_ALL PH,
950: PO_DISTRIBUTIONS_ALL PD,
951: PO_LINE_LOCATIONS_ALL PLL
952: /* Fixed bug 3115844 */

Line 1390: po_releases_all pr,

1386: FROM po_distributions_all pd,
1387: po_headers_all ph,
1388: po_lines_all pl,
1389: po_line_locations_all pll,
1390: po_releases_all pr,
1391: po_line_types plt
1392: WHERE ph.type_lookup_code = 'BLANKET'
1393: AND pr.po_release_id = pll.po_release_id
1394: AND pr.po_header_id = ph.po_header_id

Line 1737: po_releases_all pr,

1733: SELECT count(*)
1734: FROM po_distributions_all pd,
1735: po_lines_all pl,
1736: po_headers_all ph,
1737: po_releases_all pr,
1738: po_line_locations_all pll,
1739: wip_discrete_jobs wdj, -- bugfix 5000087
1740: wip_repetitive_schedules wrs, -- bugfix 5000087
1741: wip_operations wo -- bugfix 5000087

Line 1912: po_releases_all pr,

1908: po_distributions_all pd,
1909: po_headers_all ph,
1910: po_lines_all pl,
1911: po_line_locations_all pll,
1912: po_releases_all pr,
1913: wip_operation_resources wor,
1914: wip_operations wo,
1915: wip_discrete_jobs wdj,
1916: wip_repetitive_schedules wrs

Line 2308: po_releases_all pr

2304: pd.org_id ou_id -- operating unit
2305: FROM po_distributions_all pd,
2306: po_headers_all ph,
2307: po_line_locations_all pll,
2308: po_releases_all pr
2309: /* Fixed bug 3115844 */
2310: WHERE pd.po_line_id IS NOT NULL
2311: AND pd.line_location_id IS NOT NULL
2312: AND ph.type_lookup_code = 'BLANKET'

Line 2528: FROM PO_RELEASES_ALL PR,

2524: SELECT 'No PO/REQ Created'
2525: FROM DUAL
2526: WHERE NOT EXISTS
2527: (SELECT '1'
2528: FROM PO_RELEASES_ALL PR,
2529: PO_HEADERS_ALL PH,
2530: PO_DISTRIBUTIONS_ALL PD
2531: WHERE PD.WIP_ENTITY_ID = p_wip_entity_id
2532: AND PD.DESTINATION_ORGANIZATION_ID = p_organization_id

Line 2557: FROM PO_RELEASES_ALL PR,

2553: SELECT 'No PO Created'
2554: FROM DUAL
2555: WHERE NOT EXISTS
2556: (SELECT '1'
2557: FROM PO_RELEASES_ALL PR,
2558: PO_HEADERS_ALL PH,
2559: PO_DISTRIBUTIONS_ALL PD
2560: WHERE PD.WIP_ENTITY_ID = p_wip_entity_id
2561: AND PD.DESTINATION_ORGANIZATION_ID = p_organization_id