[Home] [Help]
2134: AR_SYSTEM_PARAMETERS_ALL arsysparam,
2135: RA_CUST_TRX_TYPES_ALL types,
2136: FND_CURRENCIES fndcurr,
2137: FND_DOCUMENT_SEQUENCES fds,
2138: ZX_PARTY_TAX_PROFILE ptp,
2139: RA_BATCH_SOURCES_ALL rbs,
2140: RA_CUSTOMER_TRX_ALL custtrx_prev,
2141: RA_CUSTOMER_TRX_LINES_ALL custtrxl,
2142: AR_VAT_TAX_ALL_B vat,
2704: ,1
2705: )
2706: SELECT /*+ ROWID(inv) NO_EXPAND ORDERED swap_join_inputs(upd) use_nl(fnd_curr,fds,poll)
2707: use_nl_with_index(lines AP_INVOICE_LINES_U1)
2708: use_nl_with_index(PTP ZX_PARTY_TAX_PROFILE_U2) */
2709: NVL(lines.org_id,-99) INTERNAL_ORGANIZATION_ID
2710: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2711: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
2712: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
2945: fnd_currencies fnd_curr,
2946: fnd_document_sequences fds,
2947: ap_invoice_lines_all lines,
2948: po_line_locations_all poll,
2949: zx_party_tax_profile ptp
2950: WHERE inv.rowid BETWEEN p_start_rowid AND p_end_rowid
2951: AND upd.ledger_id = inv.set_of_books_id
2952: AND (TRUNC(inv.invoice_date) between upd.start_date and upd.end_date)
2953: AND fnd_curr.currency_code = inv.invoice_currency_code
3585: use_nl_with_index(taxes ZX_TAXES_B_U2)
3586: use_nl_with_index(rates ZX_RATES_B_N2)
3587: use_nl_with_index(regimes ZX_REGIMES_B_U2)
3588: use_nl_with_index(status ZX_STATUS_B_U2)
3589: use_nl_with_index(ptp ZX_PARTY_TAX_PROFILE_U2) */
3590: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
3591: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3592: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
3593: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
3818: zx_rates_b rates,
3819: zx_regimes_b regimes,
3820: zx_taxes_b taxes,
3821: zx_status_b status,
3822: zx_party_tax_profile ptp
3823: WHERE inv.rowid BETWEEN p_start_rowid AND p_end_rowid
3824: AND upd.ledger_id = inv.set_of_books_id
3825: AND (TRUNC(inv.invoice_date) between upd.start_date and upd.end_date)
3826: AND fnd_curr.currency_code = inv.invoice_currency_code
4312: fnd_currencies fc,
4313: hr_organization_information oi,
4314: po_lines_all pol,
4315: po_line_locations_all poll,
4316: zx_party_tax_profile ptp,
4317: hr_locations_all hr
4318: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
4319: AND oi.organization_id(+) = poh.org_id
4320: AND oi.org_information_context(+) = 'Operating Unit Information'
5008: ) poh,
5009: fnd_currencies fc,
5010: po_lines_all pol,
5011: po_line_locations_all poll,
5012: zx_party_tax_profile ptp,
5013: ap_tax_codes_all atc,
5014: ar_tax_group_codes_all atg,
5015: zx_rates_b rates,
5016: zx_regimes_b regimes,