[Home] [Help]
3005: xla_upgrade_dates upd,
3006: fnd_currencies fnd_curr,
3007: fnd_document_sequences fds,
3008: ap_invoice_lines_all lines,
3009: po_line_locations_all poll,
3010: zx_party_tax_profile ptp
3011: WHERE inv.rowid BETWEEN p_start_rowid AND p_end_rowid
3012: AND upd.ledger_id = inv.set_of_books_id
3013: AND (TRUNC(inv.invoice_date) between upd.start_date and upd.end_date)
4399: ) poh,
4400: fnd_currencies fc,
4401: hr_organization_information oi,
4402: po_lines_all pol,
4403: po_line_locations_all poll,
4404: zx_party_tax_profile ptp,
4405: hr_locations_all hr
4406: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
4407: AND oi.organization_id(+) = poh.org_id
5086: AND oi.org_information_context(+) = 'Operating Unit Information'
5087: ) poh,
5088: fnd_currencies fc,
5089: po_lines_all pol,
5090: po_line_locations_all poll,
5091: zx_party_tax_profile ptp,
5092: ap_tax_codes_all atc,
5093: zx_rates_b rates,
5094: zx_regimes_b regimes,
5793: AND oi.org_information_context(+) = 'Operating Unit Information'
5794: ) poh,
5795: fnd_currencies fc,
5796: po_lines_all pol,
5797: po_line_locations_all poll,
5798: zx_party_tax_profile ptp,
5799: ap_tax_codes_all atc,
5800: ar_tax_group_codes_all atg,
5801: ap_tax_codes_all atc1,
6273: NVL(poll.po_release_id, poh.po_header_id) trx_id
6274: FROM po_headers_all poh,
6275: financials_system_params_all fsp,
6276: xla_upgrade_dates upd,
6277: po_line_locations_all poll
6278: WHERE poh.rowid BETWEEN p_start_rowid AND p_end_rowid
6279: AND NVL(poh.closed_code, 'X') <> 'FINALLY CLOSED'
6280: AND NVL(poh.org_id, -99) = NVL(fsp.org_id, -99)
6281: AND upd.ledger_id = fsp.set_of_books_id