[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
257: x_return_status OUT NOCOPY VARCHAR2) AS
258:
259: CURSOR pod_rec_rate_po IS
260: SELECT /*+ ORDERED NO_EXPAND use_nl(pod, poll,pol, atc,atg, atc1, pov)
261: INDEX (fsp financials_system_params_u1) INDEX (lgr gl_ledgers_u2)*/
262: poh.po_header_id,
263: pod.line_location_id,
264: pod.po_distribution_id,
265: NVL(atg.tax_code_id, atc.tax_id),
283: ar_tax_group_codes_all atg,
284: ap_tax_codes_all atc1,
285: po_vendors pov,
286: financials_system_params_all fsp,
287: gl_ledgers lgr
288: WHERE poh.po_header_id = p_upg_trx_info_rec.trx_id
289: AND pod.po_header_id = poh.po_header_id
290: AND pod.recovery_rate IS NULL
291: AND poll.po_header_id = pod.po_header_id
304: AND lgr.ledger_id = fsp.set_of_books_id;
305:
306: CURSOR pod_rec_rate_release IS
307: SELECT /*+ ORDERED NO_EXPAND use_nl(pod, poh, pol, atc,atg, atc1, pov)
308: INDEX (fsp financials_system_params_u1) INDEX (lgr gl_ledgers_u2)*/
309: poll.po_release_id,
310: pod.line_location_id,
311: pod.po_distribution_id,
312: NVL(atg.tax_code_id, atc.tax_id),
330: ar_tax_group_codes_all atg,
331: ap_tax_codes_all atc1,
332: po_vendors pov,
333: financials_system_params_all fsp,
334: gl_ledgers lgr
335: WHERE poll.po_release_id = p_upg_trx_info_rec.trx_id
336: AND pod.po_header_id = poll.po_header_id
337: AND pod.po_line_id = poll.po_line_id
338: AND pod.line_location_id = poll.line_location_id
527: x_return_status OUT NOCOPY VARCHAR2) AS
528:
529: CURSOR pod_rec_rate IS
530: SELECT /*+ ORDERED NO_EXPAND use_nl(pod,poll,pol, atc,atg, atc1, pov)
531: INDEX (fsp financials_system_params_u1) INDEX (lgr gl_ledgers_u2)*/
532: poh.po_header_id,
533: pod.line_location_id,
534: pod.po_distribution_id,
535: NVL(atg.tax_code_id,atc.tax_id),
559: ar_tax_group_codes_all atg,
560: ap_tax_codes_all atc1,
561: po_vendors pov,
562: financials_system_params_all fsp,
563: gl_ledgers lgr
564: WHERE poh.po_header_id = zxvalerr.other_doc_trx_id
565: AND pod.po_header_id = poh.po_header_id
566: AND pod.recovery_rate IS NULL
567: AND poll.po_header_id = pod.po_header_id
579: AND NVL(fsp.org_id, -99) = NVL(poh.org_id, -99)
580: AND lgr.ledger_id = fsp.set_of_books_id
581: UNION
582: SELECT /*+ ORDERED NO_EXPAND use_nl(pod, poh, pol, atc,atg, atc1, pov)
583: INDEX (fsp financials_system_params_u1) INDEX (lgr gl_ledgers_u2)*/
584: poll.po_release_id,
585: pod.line_location_id,
586: pod.po_distribution_id,
587: NVL(atg.tax_code_id,atc.tax_id),
611: ar_tax_group_codes_all atg,
612: ap_tax_codes_all atc1,
613: po_vendors pov,
614: financials_system_params_all fsp,
615: gl_ledgers lgr
616: WHERE poll.po_release_id = zxvalerr.other_doc_trx_id
617: AND pod.po_header_id = poll.po_header_id
618: AND pod.po_line_id = poll.po_line_id
619: AND pod.line_location_id = poll.line_location_id