1. Tables and Views for Project Management
  2. PJF_BU_CURRENCY_DETAILS_V

PJF_BU_CURRENCY_DETAILS_V

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: VIEW

Columns

Name

BU_ID

PRIMARY_LEDGER_ID

DEFAULT_RATE_DATE_CODE

DEFAULT_RATE_TYPE

CURRENCY_CODE

MINIMUM_ACCOUNTABLE_UNIT

PRECISION

EXTENDED_PRECISION

CC_DEFAULT_RATE_TYPE

CC_DEFAULT_RATE_DATE_CODE

Query

SQL_Statement

SELECT info.ORGANIZATION_ID bu_id,

INFO.ORG_INFORMATION3 primary_ledger_id,

buimpl.default_rate_date_code,

buimpl.default_rate_type,

ledgers.currency_code,

NVL( minimum_accountable_unit, power( 10, (-1 * PRECISION))) minimum_accountable_unit,

curr.precision,

curr. extended_precision,

buimpl.cc_default_rate_type,

buimpl.cc_default_rate_date_code

FROM pjf_bu_impl_all buimpl,

HR_ORGANIZATION_INFORMATION_X INFO,

gl_ledgers ledgers,

fnd_currencies curr

WHERE buimpl.org_id = info.organization_id

AND INFO.ORG_INFORMATION_CONTEXT = 'FUN_BUSINESS_UNIT'

AND ledgers.ledger_id = info.ORG_INFORMATION3

AND ledgers.currency_code = curr.currency_code