APPS.JAI_ENCUM_PRC dependencies on PO_LINE_LOCATIONS_ALL

Line 51: FROM po_line_locations_all

47: /*Cursor to fetch the po_line_id using line_location_id*/
48: CURSOR cur_po_line_id(cp_line_location_id NUMBER)
49: IS
50: SELECT po_line_id
51: FROM po_line_locations_all
52: WHERE line_location_id = cp_line_location_id;
53:
54: /*Cursor to fetch currency, conversion rate and header id of the PO*/
55: CURSOR cur_po_hdr_dtls(cp_po_line_id NUMBER)

Line 158: PO_LINE_LOCATIONS_ALL POLL

154: INTO ln_nr_tot_tax
155: FROM JAI_PO_TAXES PO_TAX,
156: JAI_CMN_TAXES_ALL TAX_CODE,
157: PO_HEADERS_ALL POH,
158: PO_LINE_LOCATIONS_ALL POLL
159: WHERE po_tax.line_location_id = poll.line_location_id
160: AND poll.po_header_id = poh.po_header_id
161: AND po_tax.tax_id = tax_code.tax_id
162: AND poll.line_location_id = ln_line_location_id

Line 173: , po_line_locations_all poll

169: INTO ln_rec_tot_inclu_tax
170: FROM jai_po_taxes po_tax
171: , jai_cmn_taxes_all tax_code
172: , po_headers_all poh
173: , po_line_locations_all poll
174: WHERE po_tax.line_location_id = poll.line_location_id
175: AND poll.po_header_id = poh.po_header_id
176: AND po_tax.tax_id = tax_code.tax_id
177: AND poll.line_location_id = ln_line_location_id

Line 215: PO_LINE_LOCATIONS_ALL POLL

211: FROM JAI_PO_TAXES PO_TAX,
212: JAI_CMN_TAXES_ALL TAX_CODE,
213: PO_HEADERS_ALL POH,
214: PO_DISTRIBUTIONS_ALL DIST,
215: PO_LINE_LOCATIONS_ALL POLL
216: WHERE po_tax.line_location_id = dist.line_location_id
217: AND dist.line_location_id = poll.line_location_id
218: AND dist.po_header_id = poh.po_header_id
219: AND po_tax.tax_id = tax_code.tax_id

Line 232: , po_line_locations_all poll

228: FROM jai_po_taxes po_tax
229: , jai_cmn_taxes_all tax_code
230: , po_headers_all poh
231: , po_distributions_all dist
232: , po_line_locations_all poll
233: WHERE po_tax.line_location_id = dist.line_location_id
234: AND dist.line_location_id = poll.line_location_id
235: AND dist.po_header_id = poh.po_header_id
236: AND po_tax.tax_id = tax_code.tax_id