APPS.WIP_OSP dependencies on PO_DISTRIBUTIONS_ALL

Line 981: PO_DISTRIBUTIONS_ALL PD,

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
984: AND pd.line_location_id IS NOT NULL
985: AND PD.WIP_ENTITY_ID = p_wip_entity_id

Line 1026: PO_DISTRIBUTIONS_ALL PD,

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 */
1029: WHERE pd.po_line_id IS NOT NULL
1030: AND pd.line_location_id IS NOT NULL

Line 1440: FROM po_distributions_all pd,

1436: pll.need_by_date old_need_by_date,
1437: pd.wip_operation_seq_num wip_op_seq,
1438: pl.item_id item_id,
1439: pd.org_id ou_id -- operating unit
1440: FROM po_distributions_all pd,
1441: po_headers_all ph,
1442: po_lines_all pl,
1443: po_line_locations_all pll,
1444: po_line_types plt

Line 1472: FROM po_distributions_all pd,

1468: pll.need_by_date old_need_by_date,
1469: pd.wip_operation_seq_num wip_op_seq,
1470: pl.item_id item_id,
1471: pd.org_id ou_id -- operating unit
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,

Line 1827: FROM po_distributions_all pd,

1823: -- Bugfix 5000087 : Modified the cursor so that it checks the PO creation
1824: -- time and throw the multiple PO error appropriately.
1825: CURSOR c_multiple_po IS
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,

Line 1953: po_distributions_all pd,

1949: ph.authorization_status approval_status,
1950: msi.primary_uom_code uom_code,
1951: pd.org_id ou_id -- operating unit
1952: FROM mtl_system_items msi,
1953: po_distributions_all pd,
1954: po_headers_all ph,
1955: po_lines_all pl,
1956: po_line_locations_all pll,
1957: wip_operation_resources wor,

Line 2029: po_distributions_all pd,

2025: pr.authorization_status approval_status,
2026: msi.primary_uom_code uom_code,
2027: pd.org_id ou_id -- operating unit
2028: FROM mtl_system_items msi,
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,

Line 2438: FROM po_distributions_all pd,

2434: ph.authorization_status approval_status,
2435: 'PO' document_type,
2436: ph.type_lookup_code document_subtype,
2437: pd.org_id ou_id -- operating unit
2438: FROM po_distributions_all pd,
2439: po_headers_all ph,
2440: po_line_locations_all pll
2441: /* Fixed bug 3115844 */
2442: WHERE pd.po_line_id IS NOT NULL

Line 2466: FROM po_distributions_all pd,

2462: pr.authorization_status approval_status,
2463: 'RELEASE' document_type,
2464: ph.type_lookup_code document_subtype,
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 */

Line 2692: PO_DISTRIBUTIONS_ALL PD

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
2695: AND (p_op_seq_num is NULL
2696: OR PD.WIP_OPERATION_SEQ_NUM = p_op_seq_num)

Line 2721: PO_DISTRIBUTIONS_ALL PD

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
2724: AND PD.WIP_REPETITIVE_SCHEDULE_ID = p_rep_sched_id
2725: AND (p_op_seq_num is NULL