DBA Data[Home] [Help]

APPS.DPP_PURCHASEPRICE_PVT dependencies on PO_RELEASES_ALL

Line 108: LEFT OUTER JOIN po_releases_all por

104: AND nvl(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED')
105: AND pll.quantity_received = 0
106: AND nvl(pll.cancel_flag,'N') = 'N'
107: AND pol.org_id = pll.org_id
108: LEFT OUTER JOIN po_releases_all por
109: ON pll.po_release_id = por.po_release_id
110: AND nvl(por.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED')
111: AND nvl(por.frozen_flag,'N') = 'N'
112: AND por.authorization_status IN ('APPROVED','REQUIRES REAPPROVAL')

Line 858: po_releases_all por

854: (pll.quantity_received > 0 OR (nvl(pol.ALLOW_PRICE_OVERRIDE_FLAG,'N') = 'N' AND poh.type_lookup_code = 'BLANKET')) AND
855: nvl(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
856: nvl(pll.cancel_flag,'N') = 'N'
857: LEFT OUTER JOIN
858: po_releases_all por
859: ON
860: pll.po_release_id = por.po_release_id AND
861: nvl(por.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
862: nvl(por.cancel_flag,'N') = 'N' AND

Line 912: po_releases_all por,

908: FROM
909: po_headers_all poh,
910: po_lines_all pol,
911: po_line_locations_all pll,
912: po_releases_all por,
913: fnd_lookup_values flv
914: WHERE
915: poh.po_header_id = pol.po_header_id AND
916: nvl(pol.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND

Line 1029: po_releases_all por

1025: ON
1026: rti.po_line_location_id = pll.line_location_id AND
1027: rti.transaction_status_code = 'PENDING'
1028: LEFT OUTER JOIN
1029: po_releases_all por
1030: ON
1031: pll.po_release_id = por.po_release_id AND
1032: nvl(por.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
1033: nvl(por.cancel_flag,'N') = 'N' AND