[Home] [Help]
105: AND nvl(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED')
106: AND pll.quantity_received = 0
107: AND nvl(pll.cancel_flag,'N') = 'N'
108: AND pol.org_id = pll.org_id
109: LEFT OUTER JOIN po_releases_all por
110: ON pll.po_release_id = por.po_release_id
111: AND nvl(por.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED')
112: AND nvl(por.frozen_flag,'N') = 'N'
113: AND por.authorization_status IN ('APPROVED','REQUIRES REAPPROVAL')
845: (pll.quantity_received > 0 OR (nvl(pol.ALLOW_PRICE_OVERRIDE_FLAG,'N') = 'N' AND poh.type_lookup_code = 'BLANKET')) AND
846: nvl(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
847: nvl(pll.cancel_flag,'N') = 'N'
848: LEFT OUTER JOIN
849: po_releases_all por
850: ON
851: pll.po_release_id = por.po_release_id AND
852: nvl(por.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
853: nvl(por.cancel_flag,'N') = 'N' AND
899: FROM
900: po_headers_all poh,
901: po_lines_all pol,
902: po_line_locations_all pll,
903: po_releases_all por,
904: fnd_lookup_values flv
905: WHERE
906: poh.po_header_id = pol.po_header_id AND
907: nvl(pol.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
1016: ON
1017: rti.po_line_location_id = pll.line_location_id AND
1018: rti.transaction_status_code = 'PENDING'
1019: LEFT OUTER JOIN
1020: po_releases_all por
1021: ON
1022: pll.po_release_id = por.po_release_id AND
1023: nvl(por.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
1024: nvl(por.cancel_flag,'N') = 'N' AND