APPS.JAI_ENCUM_PRC dependencies on PO_REQUISITION_LINES_ALL

Line 80: FROM po_requisition_lines_all

76: /*Cursor to fetch currency, conversion rate and header id of the requistion*/
77: CURSOR cur_req_line_dtls(cp_req_line_id NUMBER)
78: IS
79: SELECT currency_code, rate,requisition_header_id
80: FROM po_requisition_lines_all
81: WHERE requisition_line_id = cp_req_line_id;
82:
83: req_line_dtls_rec cur_req_line_dtls%ROWTYPE;
84:

Line 340: PO_REQUISITION_LINES_ALL lines

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
344: AND lines.requisition_line_id = ln_req_line_id

Line 363: , po_requisition_lines_all lines

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
367: AND lines.requisition_line_id = ln_req_line_id

Line 416: PO_REQUISITION_LINES_ALL lines

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
419: AND lines.requisition_line_id = dist.requisition_line_id
420: AND req_tax.tax_id = tax_code.tax_id

Line 441: , po_requisition_lines_all lines

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
444: AND lines.requisition_line_id = dist.requisition_line_id
445: AND req_tax.tax_id = tax_code.tax_id