DBA Data[Home] [Help]

APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on FND_CURRENCIES

Line 2136: FND_CURRENCIES fndcurr,

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,
2138: ZX_PARTY_TAX_PROFILE ptp,
2139: RA_BATCH_SOURCES_ALL rbs,
2140: RA_CUSTOMER_TRX_ALL custtrx_prev,

Line 2945: fnd_currencies fnd_curr,

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,
2949: zx_party_tax_profile ptp

Line 3813: fnd_currencies fnd_curr,

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,
3817: ap_invoice_lines_all lines,

Line 4312: fnd_currencies fc,

4308: AND aps.set_of_books_id = fsp.set_of_books_id
4309: AND NVL(aps.org_id, -99) = NVL(fsp.org_id, -99)
4310: AND (poh.last_update_date between upd.start_date and upd.end_date)
4311: ) poh,
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,

Line 5009: fnd_currencies fc,

5005: AND (poh.last_update_date between upd.start_date and upd.end_date)
5006: AND oi.organization_id(+) = poh.org_id
5007: 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,

Line 5442: fnd_currencies fc,

5438: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
5439: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
5440: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
5441: ) pohzd,
5442: fnd_currencies fc,
5443: zx_rates_b rates,
5444: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
5445: WHERE pohzd.trx_currency_code = fc.currency_code(+)
5446: AND rates.tax_regime_code(+) = pohzd.tax_regime_code