APPS.JAI_ENCUM_PRC dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 73: FROM po_req_distributions_all

69:
70: CURSOR cur_req_line_id(cp_distribution_id NUMBER)
71: IS
72: SELECT requisition_line_id
73: FROM po_req_distributions_all
74: WHERE distribution_id = cp_distribution_id;
75:
76: /*Cursor to fetch currency, conversion rate and header id of the requistion*/
77: CURSOR cur_req_line_dtls(cp_req_line_id NUMBER)

Line 415: PO_REQ_DISTRIBUTIONS_ALL dist,

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

Line 440: , po_req_distributions_all dist

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