eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: PA.PA_FI_AMOUNT_DETAILS_AR#

Object Details

Object Name:	PA_FI_AMOUNT_DETAILS_AR#
Object Type:	VIEW
Owner:	PA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PURGE_BATCH_ID	NUMBER	(15)	Yes
PURGE_RELEASE	VARCHAR2	(50)	Yes
PURGE_PROJECT_ID	NUMBER	(15)	Yes
FORECAST_ITEM_ID	NUMBER	(15)
LINE_NUM	NUMBER	(15)
ITEM_DATE	DATE
ITEM_UOM	VARCHAR2	(30)
ITEM_QUANTITY	NUMBER
REVERSED_FLAG	VARCHAR2	(1)
NET_ZERO_FLAG	VARCHAR2	(1)
LINE_NUM_REVERSED	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
COST_TXN_CURRENCY_CODE	VARCHAR2	(15)
TXN_RAW_COST	NUMBER
TXN_BURDENED_COST	NUMBER
REVENUE_TXN_CURRENCY_CODE	VARCHAR2	(15)
TXN_REVENUE	NUMBER
TP_TXN_CURRENCY_CODE	VARCHAR2	(15)
TXN_TRANSFER_PRICE	NUMBER
PROJECT_CURRENCY_CODE	VARCHAR2	(15)
PROJECT_COST_RATE_DATE	DATE
PROJECT_COST_RATE_TYPE	VARCHAR2	(30)
PROJECT_COST_EXCHANGE_RATE	NUMBER
PROJECT_RAW_COST	NUMBER
PROJECT_BURDENED_COST	NUMBER
PROJECT_REVENUE_RATE_DATE	DATE
PROJECT_REVENUE_RATE_TYPE	VARCHAR2	(30)
PROJECT_REVENUE_EXCHANGE_RATE	NUMBER
PROJECT_REVENUE	NUMBER
PROJECT_TP_RATE_DATE	DATE
PROJECT_TP_RATE_TYPE	VARCHAR2	(30)
PROJECT_TP_EXCHANGE_RATE	NUMBER
PROJECT_TRANSFER_PRICE	NUMBER
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)
PROJFUNC_COST_RATE_DATE	DATE
PROJFUNC_COST_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_COST_EXCHANGE_RATE	NUMBER
PROJFUNC_RAW_COST	NUMBER
PROJFUNC_BURDENED_COST	NUMBER
PROJFUNC_REVENUE	NUMBER
PROJFUNC_TRANSFER_PRICE	NUMBER
PROJFUNC_RATE_DATE	DATE
PROJFUNC_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_EXCHANGE_RATE	NUMBER
EXPFUNC_CURRENCY_CODE	VARCHAR2	(15)
EXPFUNC_COST_RATE_DATE	DATE
EXPFUNC_COST_RATE_TYPE	VARCHAR2	(30)
EXPFUNC_COST_EXCHANGE_RATE	NUMBER
EXPFUNC_RAW_COST	NUMBER
EXPFUNC_BURDENED_COST	NUMBER
EXPFUNC_TP_RATE_DATE	DATE
EXPFUNC_TP_RATE_TYPE	VARCHAR2	(30)
EXPFUNC_TP_EXCHANGE_RATE	NUMBER
EXPFUNC_TRANSFER_PRICE	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PURGE_BATCH_ID
,      PURGE_RELEASE
,      PURGE_PROJECT_ID
,      FORECAST_ITEM_ID
,      LINE_NUM
,      ITEM_DATE
,      ITEM_UOM
,      ITEM_QUANTITY
,      REVERSED_FLAG
,      NET_ZERO_FLAG
,      LINE_NUM_REVERSED
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      COST_TXN_CURRENCY_CODE
,      TXN_RAW_COST
,      TXN_BURDENED_COST
,      REVENUE_TXN_CURRENCY_CODE
,      TXN_REVENUE
,      TP_TXN_CURRENCY_CODE
,      TXN_TRANSFER_PRICE
,      PROJECT_CURRENCY_CODE
,      PROJECT_COST_RATE_DATE
,      PROJECT_COST_RATE_TYPE
,      PROJECT_COST_EXCHANGE_RATE
,      PROJECT_RAW_COST
,      PROJECT_BURDENED_COST
,      PROJECT_REVENUE_RATE_DATE
,      PROJECT_REVENUE_RATE_TYPE
,      PROJECT_REVENUE_EXCHANGE_RATE
,      PROJECT_REVENUE
,      PROJECT_TP_RATE_DATE
,      PROJECT_TP_RATE_TYPE
,      PROJECT_TP_EXCHANGE_RATE
,      PROJECT_TRANSFER_PRICE
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_COST_RATE_DATE
,      PROJFUNC_COST_RATE_TYPE
,      PROJFUNC_COST_EXCHANGE_RATE
,      PROJFUNC_RAW_COST
,      PROJFUNC_BURDENED_COST
,      PROJFUNC_REVENUE
,      PROJFUNC_TRANSFER_PRICE
,      PROJFUNC_RATE_DATE
,      PROJFUNC_RATE_TYPE
,      PROJFUNC_EXCHANGE_RATE
,      EXPFUNC_CURRENCY_CODE
,      EXPFUNC_COST_RATE_DATE
,      EXPFUNC_COST_RATE_TYPE
,      EXPFUNC_COST_EXCHANGE_RATE
,      EXPFUNC_RAW_COST
,      EXPFUNC_BURDENED_COST
,      EXPFUNC_TP_RATE_DATE
,      EXPFUNC_TP_RATE_TYPE
,      EXPFUNC_TP_EXCHANGE_RATE
,      EXPFUNC_TRANSFER_PRICE
FROM PA.PA_FI_AMOUNT_DETAILS_AR#;

Dependencies

[top of page]

PA.PA_FI_AMOUNT_DETAILS_AR# references the following:

PA: PA_FI_AMOUNT_DETAILS_AR

PA.PA_FI_AMOUNT_DETAILS_AR# is referenced by following:

APPS: PA_FI_AMOUNT_DETAILS_AR