DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on PO_DISTRIBUTIONS_ALL

Line 906: PO_DISTRIBUTIONS_ALL PD,

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

Line 950: PO_DISTRIBUTIONS_ALL PD,

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

Line 1354: FROM po_distributions_all pd,

1350: pll.need_by_date old_need_by_date,
1351: pd.wip_operation_seq_num wip_op_seq,
1352: pl.item_id item_id,
1353: pd.org_id ou_id -- operating unit
1354: FROM po_distributions_all pd,
1355: po_headers_all ph,
1356: po_lines_all pl,
1357: po_line_locations_all pll,
1358: po_line_types plt

Line 1386: FROM po_distributions_all pd,

1382: pll.need_by_date old_need_by_date,
1383: pd.wip_operation_seq_num wip_op_seq,
1384: pl.item_id item_id,
1385: pd.org_id ou_id -- operating unit
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,

Line 1734: FROM po_distributions_all pd,

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

Line 1845: po_distributions_all pd,

1841: ph.authorization_status approval_status,
1842: msi.primary_uom_code uom_code,
1843: pd.org_id ou_id -- operating unit
1844: FROM mtl_system_items msi,
1845: po_distributions_all pd,
1846: po_headers_all ph,
1847: po_lines_all pl,
1848: po_line_locations_all pll,
1849: wip_operation_resources wor,

Line 1908: po_distributions_all pd,

1904: pr.authorization_status approval_status,
1905: msi.primary_uom_code uom_code,
1906: pd.org_id ou_id -- operating unit
1907: FROM mtl_system_items msi,
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,

Line 2277: FROM po_distributions_all pd,

2273: ph.authorization_status approval_status,
2274: 'PO' document_type,
2275: ph.type_lookup_code document_subtype,
2276: pd.org_id ou_id -- operating unit
2277: FROM po_distributions_all pd,
2278: po_headers_all ph,
2279: po_line_locations_all pll
2280: /* Fixed bug 3115844 */
2281: WHERE pd.po_line_id IS NOT NULL

Line 2305: FROM po_distributions_all pd,

2301: pr.authorization_status approval_status,
2302: 'RELEASE' document_type,
2303: ph.type_lookup_code document_subtype,
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 */

Line 2530: PO_DISTRIBUTIONS_ALL PD

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

Line 2559: PO_DISTRIBUTIONS_ALL PD

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