Analytics Catalog/Data dictionary/FOS_TRANSFER_PRICE_V
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

FOS_TRANSFER_PRICE_V

SharedUsed in 1 subject areas10 reporting columns

denormalized view.

Primary key: not yet catalogued for FOS_TRANSFER_PRICE_V, reference Oracle Tables & Views guide.
Joins (inferred from key columns): CONVERSION_TYPE → GL_DAILY_CONVERSION_TYPES

Columns

ColumnKeyIn reportsDescription (inferred)
BASIS●Basis.
CONVERSION_TYPE●Type of conversion.
CURRENCY_CODE●Code identifying the currency.
PRICING_OPTION_NAME●Name of the pricing option.
TP_COST_MARKUP_VALUE●Tp cost markup value.
TP_DOC_MARKUP_VALUE●Tp doc markup value.
TP_DOC_PRICE_BASIS_FLAG●Indicator (Y/N) for the tp doc price basis.
TP_USE_SOPRICE_FLAG●Indicator (Y/N) for the tp use soprice.
UNIT_OF_MEASURE●Unit of measure.
UNIT_PRICE●Unit price.

Used by reports

No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.

Where this surfaces in OTBI

The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.

Need the extract + dbt staging for FOS_TRANSFER_PRICE_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern