DBA Data[Home] [Help]

APPS.JAI_ENCUM_PRC dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 344: PO_REQ_DISTRIBUTIONS_ALL dist,

340: (dist.req_line_quantity/lines.quantity)),2),0)
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

Line 361: , po_req_distributions_all dist

357: (dist.req_line_quantity/lines.quantity)), 2), 0)
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