DBA Data[Home] [Help]

APPS.JAI_PO_HOOK_PKG dependencies on PO_RELEASES_ALL

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

1975: */
1976: FOR r_release_rec IN (SELECT currency, SUM(tax_amount) tax_amount
1977: FROM JAI_PO_TAXES a,
1978: po_line_locations_all b,
1979: po_releases_all c -- added by pramasub #6441185
1980: WHERE b.po_header_id = p_header_id
1981: AND b.po_release_id is not null
1982: AND a.po_header_id = b.po_header_id
1983: AND a.po_line_id = b.po_line_id

Line 2723: , po_releases_all pra

2719: , SUM(jpt.tax_amount) tax_amount
2720: FROM
2721: JAI_PO_TAXES jpt
2722: , po_line_locations_all plla
2723: , po_releases_all pra
2724: , jai_cmn_taxes_all jcta
2725: WHERE plla.po_header_id = pn_header_id
2726: AND plla.po_release_id IS NOT NULL
2727: AND jpt.po_header_id = plla.po_header_id