[Home] [Help]
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,
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'
286: ap_tax_codes_all atc,
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
333: ap_tax_codes_all atc,
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
562: ap_tax_codes_all atc,
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
614: ap_tax_codes_all atc,
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