[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'
282: ap_tax_codes_all atc,
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
329: ap_tax_codes_all atc,
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
558: ap_tax_codes_all atc,
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
610: ap_tax_codes_all atc,
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