APPS.JAI_ENCUM_PRC dependencies on PO_REQUISITION_LINES_ALL

Line 74: FROM po_requisition_lines_all

70: /*Cursor to fetch currency, conversion rate and header id of the requistion*/
71: CURSOR cur_req_line_dtls(cp_req_line_id NUMBER)
72: IS
73: SELECT currency_code, rate,requisition_header_id
74: FROM po_requisition_lines_all
75: WHERE requisition_line_id = cp_req_line_id;
76:
77: req_line_dtls_rec cur_req_line_dtls%ROWTYPE;
78:

Line 291: PO_REQUISITION_LINES_ALL lines

287: DECODE(req_tax.currency,'INR',1/nvl(lines.rate, 1), 1 ) ),0)
288: INTO ln_nr_tot_tax
289: FROM JAI_PO_REQ_LINE_TAXES Req_TAX,
290: JAI_CMN_TAXES_ALL TAX_CODE,
291: PO_REQUISITION_LINES_ALL lines
292: WHERE req_tax.requisition_line_id = lines.requisition_line_id
293: AND req_tax.requisition_header_id = lines.requisition_header_id
294: AND req_tax.tax_id = tax_code.tax_id
295: AND lines.requisition_line_id = ln_req_line_id

Line 305: , po_requisition_lines_all lines

301: DECODE( req_tax.currency, 'INR',1/nvl(lines.rate, 1), 1 ) ), 0)
302: INTO ln_rec_tot_inclu_tax
303: FROM jai_po_req_line_taxes req_tax
304: , jai_cmn_taxes_all tax_code
305: , po_requisition_lines_all lines
306: WHERE req_tax.requisition_line_id = lines.requisition_line_id
307: AND req_tax.requisition_header_id = lines.requisition_header_id
308: AND req_tax.tax_id = tax_code.tax_id
309: AND lines.requisition_line_id = ln_req_line_id

Line 345: PO_REQUISITION_LINES_ALL lines

341: INTO p_nr_tax_tbl(i)
342: FROM JAI_PO_REQ_LINE_TAXES Req_TAX,
343: JAI_CMN_TAXES_ALL TAX_CODE,
344: PO_REQ_DISTRIBUTIONS_ALL dist,
345: PO_REQUISITION_LINES_ALL lines
346: WHERE req_tax.requisition_line_id = lines.requisition_line_id
347: AND req_tax.requisition_header_id = lines.requisition_header_id
348: AND lines.requisition_line_id = dist.requisition_line_id
349: AND req_tax.tax_id = tax_code.tax_id

Line 362: , po_requisition_lines_all lines

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