[Home] [Help]
995: AND nvl(por.closed_code, 'a') <> 'FINALLY CLOSED'
996: AND nvl(por.cancel_flag, 'N') = 'N')
997: OR EXISTS
998: (SELECT 'x'
999: FROM po_line_locations_all pol, po_releases_all por,
1000: po_headers_all poh
1001: WHERE poh.vendor_site_id = p_vendor_site_id
1002: AND poh.vendor_id = p_vendor_id --bug 3649022
1003: AND por.po_header_id = poh.po_header_id
1006: AND NVL(pol.closed_code, 'a') <> 'FINALLY CLOSED'
1007: AND NVL(pol.cancel_flag, 'N') = 'N')
1008: OR EXISTS
1009: (SELECT 'x'
1010: FROM po_line_locations_all pol, po_headers_all poh
1011: WHERE poh.vendor_site_id = p_vendor_site_id
1012: AND poh.vendor_id = p_vendor_id --bug 3649022
1013: AND poh.po_header_id = pol.po_header_id
1014: AND pol.consigned_flag = 'Y'
1433: --l_line_location_id NUMBER := NULL;--Bug 14664015
1434: l_item_id NUMBER := NULL;
1435: l_ship_to_organization_id NUMBER := NULL;
1436: l_consigned_flag
1437: PO_LINE_LOCATIONS.CONSIGNED_FLAG%TYPE := NULL;
1438: l_consigned_from_supplier_flag
1439: PO_ASL_ATTRIBUTES.CONSIGNED_FROM_SUPPLIER_FLAG%TYPE := NULL;
1440: l_enable_vmi_flag
1441: PO_ASL_ATTRIBUTES.ENABLE_VMI_FLAG%TYPE := NULL;
1446: SELECT DISTINCT --pll.line_location_id, --Bug 14664015
1447: pl.item_id,
1448: pll.ship_to_organization_id,
1449: pll.consigned_flag
1450: FROM po_line_locations_all pll,
1451: po_lines_all pl
1452: WHERE pll.po_header_id = p_po_header_id
1453: AND pl.po_line_id = pll.po_line_id;
1454: