[Home] [Help]
2188: FROM RA_CUSTOMER_TRX_ALL custtrx,
2189: XLA_UPGRADE_DATES upd,
2190: AR_SYSTEM_PARAMETERS_ALL arsysparam,
2191: RA_CUST_TRX_TYPES_ALL types,
2192: FND_CURRENCIES fndcurr,
2193: FND_DOCUMENT_SEQUENCES fds,
2194: ZX_PARTY_TAX_PROFILE ptp,
2195: RA_BATCH_SOURCES_ALL rbs,
2196: RA_CUSTOMER_TRX_ALL custtrx_prev,
3002: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
3003: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
3004: FROM ap_invoices_all inv,
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
3895: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
3896: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
3897: FROM ap_invoices_all inv,
3898: xla_upgrade_dates upd,
3899: fnd_currencies fnd_curr,
3900: ap_inv_dists_target ap_dists,
3901: ap_inv_dists_target ap_dists1,
3902: ap_invoice_lines_all lines1,
3903: ap_invoice_lines_all lines,
4396: AND aps.set_of_books_id = fsp.set_of_books_id
4397: AND NVL(aps.org_id, -99) = NVL(fsp.org_id, -99)
4398: AND (trunc(poh.last_update_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,
5084: AND (trunc(poh.last_update_date) between upd.start_date and upd.end_date)
5085: 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,
5791: AND (trunc(poh.last_update_date) between upd.start_date and upd.end_date)
5792: AND oi.organization_id(+) = poh.org_id
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,
6297: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
6298: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
6299: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
6300: ) pohzd,
6301: fnd_currencies fc,
6302: zx_rates_b rates,
6303: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
6304: WHERE pohzd.trx_currency_code = fc.currency_code(+)
6305: AND rates.tax_regime_code(+) = pohzd.tax_regime_code