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_INTERORG_PARAMS_REF_V

Object Details

Object Name:	CST_XLA_INTERORG_PARAMS_REF_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_XLA_INTERORG_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	Comments
FROM_ORGANIZATION_ID	NUMBER		Yes	Shipping organization identifier
TO_ORGANIZATION_ID	NUMBER		Yes	Receiving organization identifier
INTERORG_TXFR_DEBIT_ACCOUNT	NUMBER			Inter-organization transfer debit account
INTERORG_TXFR_CREDIT_ACCOUNT	NUMBER			Inter-organization transfer credit account
INTERORG_RECEIVABLES_ACCOUNT	NUMBER			Inter-organization receivables account
INTERORG_PAYABLES_ACCOUNT	NUMBER			Inter-organization payables account
INTERORG_PRICE_VAR_ACCOUNT	NUMBER			Inter-organization price variance account
PROFIT_IN_INV_ACCOUNT	NUMBER			Inter-organization profit in inventory account
INTERORG_PROFIT_ACCOUNT	NUMBER			Interorg Profit Account
INTERORG_BRIDGING_ACCOUNT	NUMBER			Inter Organization Bridging Account
INTERORG_EXPENSE_ACCOUNT	NUMBER			Inter Organization Expense Account
INTERORG_REVENUE_ACCOUNT	NUMBER			Inter Organization Revenue Account
EVENT_ID	NUMBER	(15)		XLA Event ID

Query Text

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


SELECT FROM_ORGANIZATION_ID
,      TO_ORGANIZATION_ID
,      INTERORG_TXFR_DEBIT_ACCOUNT
,      INTERORG_TXFR_CREDIT_ACCOUNT
,      INTERORG_RECEIVABLES_ACCOUNT
,      INTERORG_PAYABLES_ACCOUNT
,      INTERORG_PRICE_VAR_ACCOUNT
,      PROFIT_IN_INV_ACCOUNT
,      INTERORG_PROFIT_ACCOUNT
,      INTERORG_BRIDGING_ACCOUNT
,      INTERORG_EXPENSE_ACCOUNT
,      INTERORG_REVENUE_ACCOUNT
,      EVENT_ID
FROM APPS.CST_XLA_INTERORG_PARAMS_REF_V;

Dependencies

[top of page]

APPS.CST_XLA_INTERORG_PARAMS_REF_V references the following:

APPS: CST_XLA_INV_HEADERS_V; MTL_INTERORG_PARAMETERS; XLA_EVENTS_GT

APPS.CST_XLA_INTERORG_PARAMS_REF_V is referenced by following:

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