[Home] [Help]
2129: 'LOCATION', NULL,
2130: custtrxl.vat_tax_id) ACCOUNT_SOURCE_TAX_RATE_ID
2131:
2132: FROM RA_CUSTOMER_TRX_ALL custtrx,
2133: XLA_UPGRADE_DATES upd,
2134: AR_SYSTEM_PARAMETERS_ALL arsysparam,
2135: RA_CUST_TRX_TYPES_ALL types,
2136: FND_CURRENCIES fndcurr,
2137: FND_DOCUMENT_SEQUENCES fds,
2940: ,DECODE(lines.discarded_flag, 'Y', 'Y', 'N') CANCEL_FLAG
2941: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
2942: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
2943: FROM ap_invoices_all inv,
2944: xla_upgrade_dates upd,
2945: fnd_currencies fnd_curr,
2946: fnd_document_sequences fds,
2947: ap_invoice_lines_all lines,
2948: po_line_locations_all poll,
3808: AND tax_class = 'INPUT') RECOVERY_RATE_ID
3809: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
3810: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
3811: FROM ap_invoices_all inv,
3812: xla_upgrade_dates upd,
3813: fnd_currencies fnd_curr,
3814: ap_inv_dists_target ap_dists,
3815: ap_inv_dists_target ap_dists1,
3816: ap_invoice_lines_all lines1,
4298: fsp.set_of_books_id,
4299: aps.base_currency_code
4300: FROM po_headers_all poh,
4301: financials_system_params_all fsp,
4302: xla_upgrade_dates upd,
4303: ap_system_parameters_all aps
4304: WHERE poh.rowid BETWEEN p_start_rowid AND p_end_rowid
4305: AND NVL(poh.closed_code, 'X') <> 'FINALLY CLOSED'
4306: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
4992: poh.* , fsp.org_id fsp_org_id, fsp.set_of_books_id,
4993: aps.base_currency_code, oi.org_information2
4994: FROM po_headers_all poh,
4995: financials_system_params_all fsp,
4996: xla_upgrade_dates upd,
4997: ap_system_parameters_all aps,
4998: hr_organization_information oi
4999: WHERE poh.rowid BETWEEN p_start_rowid AND p_end_rowid
5000: AND NVL(poh.closed_code, 'X') <> 'FINALLY CLOSED'
5413: NVL2(poll.po_release_id, 'RELEASE', 'PO_PA') event_class_code,
5414: NVL(poll.po_release_id, poh.po_header_id) trx_id
5415: FROM po_headers_all poh,
5416: financials_system_params_all fsp,
5417: xla_upgrade_dates upd,
5418: po_line_locations_all poll
5419: WHERE poh.rowid BETWEEN p_start_rowid AND p_end_rowid
5420: AND NVL(poh.closed_code, 'X') <> 'FINALLY CLOSED'
5421: AND NVL(poh.org_id, -99) = NVL(fsp.org_id, -99)