eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_ENCUM_PRC dependencies on JAI_CMN_TAXES_ALL

Line 166: JAI_CMN_TAXES_ALL TAX_CODE,

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
170: AND poll.po_header_id = poh.po_header_id

Line 190: , jai_cmn_taxes_all tax_code

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
194: AND poll.po_header_id = poh.po_header_id

Line 245: JAI_CMN_TAXES_ALL TAX_CODE,

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
249: WHERE po_tax.line_location_id = dist.line_location_id

Line 271: , jai_cmn_taxes_all tax_code

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
275: WHERE po_tax.line_location_id = dist.line_location_id

Line 339: JAI_CMN_TAXES_ALL TAX_CODE,

335: ,1 )
336: * DECODE(req_tax.currency,'INR',1,lines.rate) ),0)
337: INTO ln_nr_tot_tax
338: FROM JAI_PO_REQ_LINE_TAXES Req_TAX,
339: JAI_CMN_TAXES_ALL TAX_CODE,
340: PO_REQUISITION_LINES_ALL lines
341: WHERE req_tax.requisition_line_id = lines.requisition_line_id
342: AND req_tax.requisition_header_id = lines.requisition_header_id
343: AND req_tax.tax_id = tax_code.tax_id

Line 362: , jai_cmn_taxes_all tax_code

358: INTO
359: ln_rec_tot_inclu_tax
360: FROM
361: jai_po_req_line_taxes req_tax
362: , jai_cmn_taxes_all tax_code
363: , po_requisition_lines_all lines
364: WHERE req_tax.requisition_line_id = lines.requisition_line_id
365: AND req_tax.requisition_header_id = lines.requisition_header_id
366: AND req_tax.tax_id = tax_code.tax_id

Line 414: JAI_CMN_TAXES_ALL TAX_CODE,

410: ,1 )
411: * DECODE(req_tax.currency,'INR',1,lines.rate) * (dist.req_line_quantity/lines.quantity)),2),0)
412: INTO p_nr_tax_tbl(i)
413: FROM JAI_PO_REQ_LINE_TAXES Req_TAX,
414: JAI_CMN_TAXES_ALL TAX_CODE,
415: PO_REQ_DISTRIBUTIONS_ALL dist,
416: PO_REQUISITION_LINES_ALL lines
417: WHERE req_tax.requisition_line_id = lines.requisition_line_id
418: AND req_tax.requisition_header_id = lines.requisition_header_id

Line 439: , jai_cmn_taxes_all tax_code

435: INTO
436: ln_rec_tax_inclu
437: FROM
438: jai_po_req_line_taxes req_tax
439: , jai_cmn_taxes_all tax_code
440: , po_req_distributions_all dist
441: , po_requisition_lines_all lines
442: WHERE req_tax.requisition_line_id = lines.requisition_line_id
443: AND req_tax.requisition_header_id = lines.requisition_header_id