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: APPS.CST_XLA_INV_ORG_PARAMS_REF_V

Object Details

Object Name:	CST_XLA_INV_ORG_PARAMS_REF_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_XLA_INV_ORG_PARAMS_REF_V
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.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
INV_ORGANIZATION_ID	NUMBER		Yes
MASTER_ORGANIZATION_ID	NUMBER		Yes
PRIMARY_COST_METHOD	NUMBER		Yes
COST_ORGANIZATION_ID	NUMBER		Yes
MAINT_ORGANIZATION_ID	NUMBER
PROJECT_REFERENCE_ENABLED	VARCHAR2	(1)
PM_COST_COLLECTION_ENABLED	VARCHAR2	(1)
PROJECT_CONTROL_LEVEL	NUMBER
AVG_RATES_COST_TYPE_ID	NUMBER
AVG_RATES_COST_TYPE	VARCHAR2	(10)
BOM_SNAPSHOT_FLAG	VARCHAR2	(1)
ALLOW_UPDATES_FLAG	VARCHAR2	(1)
AVAILABLE_TO_ENG_FLAG	VARCHAR2	(1)
PROCESS_ENABLED_FLAG	VARCHAR2	(1)
WSM_ENABLED_FLAG	VARCHAR2	(1)
WMS_ENABLED_FLAG	VARCHAR2	(1)
EAM_ENABLED_FLAG	VARCHAR2	(1)
CONSIGNED_ORG_FLAG	VARCHAR2	(1)
WCS_ENABLED	VARCHAR2	(1)
DEFER_LOGICAL_TRANSACTIONS	VARCHAR2	(1)
COST_GROUP_ACCOUNTING	VARCHAR2	(1)
COST_CUTOFF_DATE	DATE
ENCUMBRANCE_REVERSAL_FLAG	VARCHAR2	(1)
ORG_INV_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ORG_INV_ATTRIBUTE1	VARCHAR2	(150)
ORG_INV_ATTRIBUTE2	VARCHAR2	(150)
ORG_INV_ATTRIBUTE3	VARCHAR2	(150)
ORG_INV_ATTRIBUTE4	VARCHAR2	(150)
ORG_INV_ATTRIBUTE5	VARCHAR2	(150)
ORG_INV_ATTRIBUTE6	VARCHAR2	(150)
ORG_INV_ATTRIBUTE7	VARCHAR2	(150)
ORG_INV_ATTRIBUTE8	VARCHAR2	(150)
ORG_INV_ATTRIBUTE9	VARCHAR2	(150)
ORG_INV_ATTRIBUTE10	VARCHAR2	(150)
ORG_INV_ATTRIBUTE11	VARCHAR2	(150)
ORG_INV_ATTRIBUTE12	VARCHAR2	(150)
ORG_INV_ATTRIBUTE13	VARCHAR2	(150)
ORG_INV_ATTRIBUTE14	VARCHAR2	(150)
ORG_INV_ATTRIBUTE15	VARCHAR2	(150)
INV_ORG_AVG_COST_VAR_ACCT	NUMBER
INV_ORG_PUR_PRICE_VAR_ACCT	NUMBER
INV_ORG_EXPENSE_ACCT	NUMBER

Query Text

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


SELECT INV_ORGANIZATION_ID
,      MASTER_ORGANIZATION_ID
,      PRIMARY_COST_METHOD
,      COST_ORGANIZATION_ID
,      MAINT_ORGANIZATION_ID
,      PROJECT_REFERENCE_ENABLED
,      PM_COST_COLLECTION_ENABLED
,      PROJECT_CONTROL_LEVEL
,      AVG_RATES_COST_TYPE_ID
,      AVG_RATES_COST_TYPE
,      BOM_SNAPSHOT_FLAG
,      ALLOW_UPDATES_FLAG
,      AVAILABLE_TO_ENG_FLAG
,      PROCESS_ENABLED_FLAG
,      WSM_ENABLED_FLAG
,      WMS_ENABLED_FLAG
,      EAM_ENABLED_FLAG
,      CONSIGNED_ORG_FLAG
,      WCS_ENABLED
,      DEFER_LOGICAL_TRANSACTIONS
,      COST_GROUP_ACCOUNTING
,      COST_CUTOFF_DATE
,      ENCUMBRANCE_REVERSAL_FLAG
,      ORG_INV_ATTRIBUTE_CATEGORY
,      ORG_INV_ATTRIBUTE1
,      ORG_INV_ATTRIBUTE2
,      ORG_INV_ATTRIBUTE3
,      ORG_INV_ATTRIBUTE4
,      ORG_INV_ATTRIBUTE5
,      ORG_INV_ATTRIBUTE6
,      ORG_INV_ATTRIBUTE7
,      ORG_INV_ATTRIBUTE8
,      ORG_INV_ATTRIBUTE9
,      ORG_INV_ATTRIBUTE10
,      ORG_INV_ATTRIBUTE11
,      ORG_INV_ATTRIBUTE12
,      ORG_INV_ATTRIBUTE13
,      ORG_INV_ATTRIBUTE14
,      ORG_INV_ATTRIBUTE15
,      INV_ORG_AVG_COST_VAR_ACCT
,      INV_ORG_PUR_PRICE_VAR_ACCT
,      INV_ORG_EXPENSE_ACCT
FROM APPS.CST_XLA_INV_ORG_PARAMS_REF_V;

Dependencies

[top of page]

APPS.CST_XLA_INV_ORG_PARAMS_REF_V references the following:

APPS: CST_COST_TYPES; MTL_PARAMETERS

APPS.CST_XLA_INV_ORG_PARAMS_REF_V is referenced by following:

APPS: XLA_00707_AAD_S_000005_BC_PKG - show dependent code; XLA_00707_AAD_S_000019_PKG - show dependent code; XLA_00707_AAD_S_000020_BC_PKG - show dependent code; XLA_00707_AAD_S_000020_PKG - show dependent code