DBA Data[Home] [Help]

APPS.JAI_PO_HOOK_PKG dependencies on PO_RELEASES_ALL

Line 2167: po_releases_all c -- added by pramasub #6441185

2163: */
2164: FOR r_release_rec IN (SELECT currency, SUM(tax_amount) tax_amount
2165: FROM JAI_PO_TAXES a,
2166: po_line_locations_all b,
2167: po_releases_all c -- added by pramasub #6441185
2168: WHERE b.po_header_id = p_header_id
2169: AND b.po_release_id is not null
2170: AND a.po_header_id = b.po_header_id
2171: AND a.po_line_id = b.po_line_id

Line 2925: , po_releases_all pra

2921: , SUM(jpt.tax_amount) tax_amount
2922: FROM
2923: JAI_PO_TAXES jpt
2924: , po_line_locations_all plla
2925: , po_releases_all pra
2926: , jai_cmn_taxes_all jcta
2927: WHERE plla.po_header_id = pn_header_id
2928: AND plla.po_release_id IS NOT NULL
2929: AND jpt.po_header_id = plla.po_header_id