APPS.JAI_ENCUM_PRC dependencies on PO_HEADERS_ALL

Line 64: FROM po_headers_all poh, po_lines_all pol

60: /*Cursor to fetch currency, conversion rate and header id of the PO*/
61: CURSOR cur_po_hdr_dtls(cp_po_line_id NUMBER)
62: IS
63: SELECT poh.currency_code, poh.rate,poh.po_header_id
64: FROM po_headers_all poh, po_lines_all pol
65: WHERE poh.po_header_id = pol.po_header_id
66: AND pol.po_line_id = cp_po_line_id;
67:
68: po_hdr_dtls_rec cur_po_hdr_dtls%ROWTYPE;

Line 167: PO_HEADERS_ALL POH,

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
171: AND po_tax.tax_id = tax_code.tax_id

Line 191: , po_headers_all poh

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
195: AND po_tax.tax_id = tax_code.tax_id

Line 246: PO_HEADERS_ALL POH,

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
250: AND dist.line_location_id = poll.line_location_id

Line 272: , po_headers_all poh

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
276: AND dist.line_location_id = poll.line_location_id