[Home] [Help]
51: atc1.tax_recovery_rate,
52: pov.vendor_type_lookup_code
53: FROM
54: ( SELECT /*+ ROWID(poh) NO_MERGE swap_join_inputs(fsp) swap_join_inputs(lgr)
55: INDEX (fsp financials_system_params_u1) INDEX (lgr gl_ledgers_u2)*/
56: poh.po_header_id, poh.last_update_date,poh.vendor_id,poh.vendor_site_id,
57: fsp.set_of_books_id, fsp.org_id, fsp.inventory_organization_id,
58: lgr.chart_of_accounts_id
59: FROM po_headers_all poh,
58: lgr.chart_of_accounts_id
59: FROM po_headers_all poh,
60: financials_system_params_all fsp,
61: xla_upgrade_dates upd,
62: gl_ledgers lgr
63: WHERE poh.rowid BETWEEN p_start_rowid AND p_end_rowid
64: AND NVL(poh.closed_code, 'OPEN') <> 'FINALLY CLOSED'
65: AND NVL(poh.org_id, -99) = NVL(fsp.org_id, -99)
66: AND upd.ledger_id = fsp.set_of_books_id
261: x_return_status OUT NOCOPY VARCHAR2) AS
262:
263: CURSOR pod_rec_rate_po IS
264: SELECT /*+ ORDERED NO_EXPAND use_nl(pod, poll,pol, atc,atg, atc1, pov)
265: INDEX (fsp financials_system_params_u1) INDEX (lgr gl_ledgers_u2)*/
266: poh.po_header_id,
267: pod.line_location_id,
268: pod.po_distribution_id,
269: NVL(atg.tax_code_id, atc.tax_id),
287: ar_tax_group_codes_all atg,
288: ap_tax_codes_all atc1,
289: po_vendors pov,
290: financials_system_params_all fsp,
291: gl_ledgers lgr
292: WHERE poh.po_header_id = p_upg_trx_info_rec.trx_id
293: AND pod.po_header_id = poh.po_header_id
294: AND pod.recovery_rate IS NULL
295: AND poll.po_header_id = pod.po_header_id
308: AND lgr.ledger_id = fsp.set_of_books_id;
309:
310: CURSOR pod_rec_rate_release IS
311: SELECT /*+ ORDERED NO_EXPAND use_nl(pod, poh, pol, atc,atg, atc1, pov)
312: INDEX (fsp financials_system_params_u1) INDEX (lgr gl_ledgers_u2)*/
313: poll.po_release_id,
314: pod.line_location_id,
315: pod.po_distribution_id,
316: NVL(atg.tax_code_id, atc.tax_id),
334: ar_tax_group_codes_all atg,
335: ap_tax_codes_all atc1,
336: po_vendors pov,
337: financials_system_params_all fsp,
338: gl_ledgers lgr
339: WHERE poll.po_release_id = p_upg_trx_info_rec.trx_id
340: AND pod.po_header_id = poll.po_header_id
341: AND pod.po_line_id = poll.po_line_id
342: AND pod.line_location_id = poll.line_location_id
531: x_return_status OUT NOCOPY VARCHAR2) AS
532:
533: CURSOR pod_rec_rate IS
534: SELECT /*+ ORDERED NO_EXPAND use_nl(pod,poll,pol, atc,atg, atc1, pov)
535: INDEX (fsp financials_system_params_u1) INDEX (lgr gl_ledgers_u2)*/
536: poh.po_header_id,
537: pod.line_location_id,
538: pod.po_distribution_id,
539: NVL(atg.tax_code_id,atc.tax_id),
563: ar_tax_group_codes_all atg,
564: ap_tax_codes_all atc1,
565: po_vendors pov,
566: financials_system_params_all fsp,
567: gl_ledgers lgr
568: WHERE poh.po_header_id = zxvalerr.other_doc_trx_id
569: AND pod.po_header_id = poh.po_header_id
570: AND pod.recovery_rate IS NULL
571: AND poll.po_header_id = pod.po_header_id
583: AND NVL(fsp.org_id, -99) = NVL(poh.org_id, -99)
584: AND lgr.ledger_id = fsp.set_of_books_id
585: UNION
586: SELECT /*+ ORDERED NO_EXPAND use_nl(pod, poh, pol, atc,atg, atc1, pov)
587: INDEX (fsp financials_system_params_u1) INDEX (lgr gl_ledgers_u2)*/
588: poll.po_release_id,
589: pod.line_location_id,
590: pod.po_distribution_id,
591: NVL(atg.tax_code_id,atc.tax_id),
615: ar_tax_group_codes_all atg,
616: ap_tax_codes_all atc1,
617: po_vendors pov,
618: financials_system_params_all fsp,
619: gl_ledgers lgr
620: WHERE poll.po_release_id = zxvalerr.other_doc_trx_id
621: AND pod.po_header_id = poll.po_header_id
622: AND pod.po_line_id = poll.po_line_id
623: AND pod.line_location_id = poll.line_location_id