APPS.WIP_OSP dependencies on PO_RELEASES_ALL

Line 979: FROM PO_RELEASES_ALL PR,

975: */
976:
977: CURSOR disc_check_po_req_cur IS
978: SELECT 'PO/REQ Linked'
979: FROM PO_RELEASES_ALL PR,
980: PO_HEADERS_ALL PH,
981: PO_DISTRIBUTIONS_ALL PD,
982: PO_LINE_LOCATIONS_ALL PLL /* Added as part of Bug2308832 */ /* Fixed bug 3115844 */
983: WHERE pd.po_line_id IS NOT NULL

Line 1024: FROM PO_RELEASES_ALL PR,

1020:
1021:
1022: CURSOR rep_check_po_req_cur IS
1023: SELECT 'PO/REQ Linked'
1024: FROM PO_RELEASES_ALL PR,
1025: PO_HEADERS_ALL PH,
1026: PO_DISTRIBUTIONS_ALL PD,
1027: PO_LINE_LOCATIONS_ALL PLL
1028: /* Fixed bug 3115844 */

Line 1476: po_releases_all pr,

1472: FROM po_distributions_all pd,
1473: po_headers_all ph,
1474: po_lines_all pl,
1475: po_line_locations_all pll,
1476: po_releases_all pr,
1477: po_line_types plt
1478: WHERE ph.type_lookup_code = 'BLANKET'
1479: AND pr.po_release_id = pll.po_release_id
1480: AND pr.po_header_id = ph.po_header_id

Line 1830: po_releases_all pr,

1826: SELECT count(*)
1827: FROM po_distributions_all pd,
1828: po_lines_all pl,
1829: po_headers_all ph,
1830: po_releases_all pr,
1831: po_line_locations_all pll,
1832: wip_discrete_jobs wdj, -- bugfix 5000087
1833: wip_repetitive_schedules wrs, -- bugfix 5000087
1834: wip_operations wo -- bugfix 5000087

Line 2033: po_releases_all pr,

2029: po_distributions_all pd,
2030: po_headers_all ph,
2031: po_lines_all pl,
2032: po_line_locations_all pll,
2033: po_releases_all pr,
2034: wip_operation_resources wor,
2035: wip_operations wo,
2036: wip_discrete_jobs wdj,
2037: wip_repetitive_schedules wrs

Line 2469: po_releases_all pr

2465: pd.org_id ou_id -- operating unit
2466: FROM po_distributions_all pd,
2467: po_headers_all ph,
2468: po_line_locations_all pll,
2469: po_releases_all pr
2470: /* Fixed bug 3115844 */
2471: WHERE pd.po_line_id IS NOT NULL
2472: AND pd.line_location_id IS NOT NULL
2473: AND ph.type_lookup_code = 'BLANKET'

Line 2690: FROM PO_RELEASES_ALL PR,

2686: SELECT 'No PO/REQ Created'
2687: FROM DUAL
2688: WHERE NOT EXISTS
2689: (SELECT '1'
2690: FROM PO_RELEASES_ALL PR,
2691: PO_HEADERS_ALL PH,
2692: PO_DISTRIBUTIONS_ALL PD
2693: WHERE PD.WIP_ENTITY_ID = p_wip_entity_id
2694: AND PD.DESTINATION_ORGANIZATION_ID = p_organization_id

Line 2719: FROM PO_RELEASES_ALL PR,

2715: SELECT 'No PO Created'
2716: FROM DUAL
2717: WHERE NOT EXISTS
2718: (SELECT '1'
2719: FROM PO_RELEASES_ALL PR,
2720: PO_HEADERS_ALL PH,
2721: PO_DISTRIBUTIONS_ALL PD
2722: WHERE PD.WIP_ENTITY_ID = p_wip_entity_id
2723: AND PD.DESTINATION_ORGANIZATION_ID = p_organization_id