[Home] [Help]
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
911: AND PD.DESTINATION_ORGANIZATION_ID = p_organization_id
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
955: AND PD.WIP_ENTITY_ID = p_wip_entity_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
1359: WHERE ph.type_lookup_code = 'STANDARD'
1360: AND ph.po_header_id = pd.po_header_id
1361: AND pd.po_line_id = pl.po_line_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,
1391: po_line_types plt
1392: WHERE ph.type_lookup_code = 'BLANKET'
1393: AND pr.po_release_id = pll.po_release_id
1422: po_requisition_lines_all prl,
1423: po_line_types plt
1424: WHERE NOT EXISTS
1425: (SELECT 'x'
1426: FROM po_line_locations_all pll
1427: WHERE prl.line_location_id = pll.line_location_id)
1428: AND prh.requisition_header_id = prl.requisition_header_id
1429: AND prl.line_type_id = plt.line_type_id
1430: AND plt.outside_operation_flag = 'Y'
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
1742: WHERE pd.po_line_id = pl.po_line_id
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,
1850: wip_operations wo,
1851: wip_discrete_jobs wdj,
1852: wip_repetitive_schedules wrs
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,
1913: wip_operation_resources wor,
1914: wip_operations wo,
1915: wip_discrete_jobs wdj,
1982: wip_discrete_jobs wdj,
1983: wip_repetitive_schedules wrs
1984: WHERE NOT EXISTS
1985: (SELECT 'x'
1986: FROM po_line_locations_all pll
1987: WHERE prl.line_location_id = pll.line_location_id)
1988: AND prh.requisition_header_id = prl.requisition_header_id
1989: AND prl.wip_entity_id = wdj.wip_entity_id (+)
1990: AND prl.destination_organization_id = wdj.organization_id (+)
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
2282: AND pd.line_location_id IS NOT NULL
2283: AND ph.type_lookup_code = 'STANDARD'
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 */
2310: WHERE pd.po_line_id IS NOT NULL
2311: AND pd.line_location_id IS NOT NULL
2338: FROM po_requisition_headers_all prh,
2339: po_requisition_lines_all prl
2340: WHERE NOT EXISTS
2341: (SELECT 'x'
2342: FROM po_line_locations_all pll
2343: WHERE prl.line_location_id = pll.line_location_id)
2344: AND prh.requisition_header_id = prl.requisition_header_id
2345: AND prl.wip_entity_id = p_job_id
2346: AND prl.destination_organization_id = p_org_id