DBA Data[Home] [Help]

APPS.JAI_ENCUM_PRC dependencies on JAI_PO_TAXES

Line 165: FROM JAI_PO_TAXES PO_TAX,

161: ,((100-nvl(tax_code.mod_cr_percentage,0))/100)
162: ,1 )
163: * DECODE(po_tax.currency,'INR',1/nvl(poh.rate,1),1) ),0)
164: INTO ln_nr_tot_tax
165: FROM JAI_PO_TAXES PO_TAX,
166: JAI_CMN_TAXES_ALL TAX_CODE,
167: PO_HEADERS_ALL POH,
168: PO_LINE_LOCATIONS_ALL POLL
169: WHERE po_tax.line_location_id = poll.line_location_id

Line 189: jai_po_taxes po_tax

185: ), 0)
186: INTO
187: ln_rec_tot_inclu_tax
188: FROM
189: jai_po_taxes po_tax
190: , jai_cmn_taxes_all tax_code
191: , po_headers_all poh
192: , po_line_locations_all poll
193: WHERE po_tax.line_location_id = poll.line_location_id

Line 244: FROM JAI_PO_TAXES PO_TAX,

240: ,1 )
241: * DECODE(po_tax.currency,'INR',1/nvl(poh.rate,1),1)
242: * ( dist.quantity_ordered / poll.quantity )),2),0)
243: INTO p_nr_tax_tbl(i)
244: FROM JAI_PO_TAXES PO_TAX,
245: JAI_CMN_TAXES_ALL TAX_CODE,
246: PO_HEADERS_ALL POH,
247: PO_DISTRIBUTIONS_ALL DIST,
248: PO_LINE_LOCATIONS_ALL POLL

Line 270: jai_po_taxes po_tax

266: ), 2), 0)
267: INTO
268: ln_rec_tax_inclu
269: FROM
270: jai_po_taxes po_tax
271: , jai_cmn_taxes_all tax_code
272: , po_headers_all poh
273: , po_distributions_all dist
274: , po_line_locations_all poll