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]

TABLE: FII.FII_AR_REVENUE_STG

Object Details

Object Name:	FII_AR_REVENUE_STG
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_AR_REVENUE_STG
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
REVENUE_PK	VARCHAR2	(80)	Yes
SET_OF_BOOKS_ID	NUMBER	(10)		No longer used.
OPERATING_UNIT_ID	NUMBER	(15)
PROD_CATEGORY_ID	NUMBER
COMPANY_COST_CENTER_ORG_ID	NUMBER	(15)		No longer used
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes
ORGANIZATION_ID	NUMBER
INVOICE_ID	NUMBER
INVOICE_LINE_ID	NUMBER
TOP_MODEL_ITEM_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER
ORDER_LINE_ID	NUMBER
BILL_TO_PARTY_ID	NUMBER
GL_DATE_ID	NUMBER		Yes
GL_DATE	DATE		Yes
SALES_CHANNEL	VARCHAR2	(30)
INVOICE_NUMBER	VARCHAR2	(30)	Yes
ORDER_NUMBER	VARCHAR2	(30)
TRANSACTION_CLASS	VARCHAR2	(3)
FUNCTIONAL_CURRENCY	VARCHAR2	(15)	Yes
TRANSACTION_CURRENCY	VARCHAR2	(15)	Yes
AMOUNT_T	NUMBER
AMOUNT_B	NUMBER
POSTED_FLAG	VARCHAR2	(1)	Yes
EXCHANGE_DATE	DATE
PRIM_CONVERSION_RATE	NUMBER
SEC_CONVERSION_RATE	NUMBER
INVOICE_DATE	DATE			Invoice Date
FIN_CATEGORY_ID	NUMBER	(15)		Financial Category Identifier
COMPANY_ID	NUMBER	(15)		Company Identifier
COST_CENTER_ID	NUMBER	(15)		Cost Center Identifier
FIN_CAT_TYPE_CODE	VARCHAR2	(30)		Financial Category Type Code
ITEM_ORGANIZATION_ID	NUMBER	(15)		Item Organization ID
OM_PRODUCT_REVENUE_FLAG	VARCHAR2	(1)		OM product revenue flag
REV_BOOKED_DATE	DATE			Revenue Booked Date
CHILD_ORDER_LINE_ID	VARCHAR2	(30)		Child Order Line Identifier
LEDGER_ID	NUMBER	(10)		Ledger Identifier

Query Text

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


SELECT REVENUE_PK
,      SET_OF_BOOKS_ID
,      OPERATING_UNIT_ID
,      PROD_CATEGORY_ID
,      COMPANY_COST_CENTER_ORG_ID
,      CHART_OF_ACCOUNTS_ID
,      ORGANIZATION_ID
,      INVOICE_ID
,      INVOICE_LINE_ID
,      TOP_MODEL_ITEM_ID
,      INVENTORY_ITEM_ID
,      ORDER_LINE_ID
,      BILL_TO_PARTY_ID
,      GL_DATE_ID
,      GL_DATE
,      SALES_CHANNEL
,      INVOICE_NUMBER
,      ORDER_NUMBER
,      TRANSACTION_CLASS
,      FUNCTIONAL_CURRENCY
,      TRANSACTION_CURRENCY
,      AMOUNT_T
,      AMOUNT_B
,      POSTED_FLAG
,      EXCHANGE_DATE
,      PRIM_CONVERSION_RATE
,      SEC_CONVERSION_RATE
,      INVOICE_DATE
,      FIN_CATEGORY_ID
,      COMPANY_ID
,      COST_CENTER_ID
,      FIN_CAT_TYPE_CODE
,      ITEM_ORGANIZATION_ID
,      OM_PRODUCT_REVENUE_FLAG
,      REV_BOOKED_DATE
,      CHILD_ORDER_LINE_ID
,      LEDGER_ID
FROM FII.FII_AR_REVENUE_STG;

Dependencies

[top of page]

FII.FII_AR_REVENUE_STG does not reference any database object

FII.FII_AR_REVENUE_STG is referenced by following:

APPS: FII_AR_REVENUE_STG