[Home] [Help]
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
986: AND PD.DESTINATION_ORGANIZATION_ID = p_organization_id
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
1031: AND PD.WIP_ENTITY_ID = p_wip_entity_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
1445: WHERE ph.type_lookup_code = 'STANDARD'
1446: AND ph.po_header_id = pd.po_header_id
1447: AND pd.po_line_id = pl.po_line_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,
1477: po_line_types plt
1478: WHERE ph.type_lookup_code = 'BLANKET'
1479: AND pr.po_release_id = pll.po_release_id
1508: po_requisition_lines_all prl,
1509: po_line_types plt
1510: WHERE NOT EXISTS
1511: (SELECT 'x'
1512: FROM po_line_locations_all pll
1513: WHERE prl.line_location_id = pll.line_location_id)
1514: AND prh.requisition_header_id = prl.requisition_header_id
1515: AND prl.line_type_id = plt.line_type_id
1516: AND plt.outside_operation_flag = 'Y'
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
1835: WHERE pd.po_line_id = pl.po_line_id
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,
1958: wip_operations wo,
1959: wip_discrete_jobs wdj,
1960: wip_repetitive_schedules wrs
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,
2034: wip_operation_resources wor,
2035: wip_operations wo,
2036: wip_discrete_jobs wdj,
2103: wip_discrete_jobs wdj,
2104: wip_repetitive_schedules wrs
2105: WHERE NOT EXISTS
2106: (SELECT 'x'
2107: FROM po_line_locations_all pll
2108: WHERE prl.line_location_id = pll.line_location_id)
2109: AND prh.requisition_header_id = prl.requisition_header_id
2110: AND prl.wip_entity_id = wdj.wip_entity_id (+)
2111: AND prl.destination_organization_id = wdj.organization_id (+)
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
2443: AND pd.line_location_id IS NOT NULL
2444: AND ph.type_lookup_code = 'STANDARD'
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 */
2471: WHERE pd.po_line_id IS NOT NULL
2472: AND pd.line_location_id IS NOT NULL
2499: FROM po_requisition_headers_all prh,
2500: po_requisition_lines_all prl
2501: WHERE NOT EXISTS
2502: (SELECT 'x'
2503: FROM po_line_locations_all pll
2504: WHERE prl.line_location_id = pll.line_location_id)
2505: AND prh.requisition_header_id = prl.requisition_header_id
2506: AND prl.wip_entity_id = p_job_id
2507: AND prl.destination_organization_id = p_org_id