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.GMF_XLA_ORG_PARAMETERS_V

Object Details

Object Name:	GMF_XLA_ORG_PARAMETERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMF.GMF_XLA_ORG_PARAMETERS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View for SLA ADR sources from Inventory Organization parameters.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
ORGANIZATION_CODE	VARCHAR2	(3)		Organization Code
MASTER_ORGANIZATION_CODE	VARCHAR2	(3)		Master Organization Code
CONSIGNED_FLAG	VARCHAR2	(1)		Indicate whether Consigned/VMI Stock was ever received
WMS_ENABLED_FLAG	VARCHAR2	(1)		WMS (Warehouse Management System) Organization
ORG_PARAM_PPV_ACCOUNT	NUMBER			Purchase price variance account
ORG_PARAM_AP_ACCRUAL_ACCOUNT	NUMBER			Accounts payable accrual account
ORG_PARAM_ITR_ACCOUNT	NUMBER			Inter-organization transfer debit account
ORG_PARAM_IOR_ACCOUNT	NUMBER			Inter-organization receivables account
ORG_PARAM_IOP_ACCOUNT	NUMBER			Inter-organization payables account
ORG_PARAM_COGS_ACCOUNT	NUMBER			Cost of sales account
ORG_PARAM_XFER_CREDIT_ACCOUNT	NUMBER			Inter-organization transfer credit account
ORG_PARAM_IPV_ACCOUNT	NUMBER			Invoice price variance account
ORG_PARAM_EXPENSE_ACCOUNT	NUMBER			Expense account
ORG_PARAM_DISTR_ACCOUNT_ID	NUMBER			Distribution Account
ORG_PARAM_DCOGS_ACCOUNT	NUMBER			Deferred COGS account which holds the costs till revenue is recognized.
INV_ORG_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
INV_ORG_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
INV_ORG_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
INV_ORG_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
INV_ORG_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
INV_ORG_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
INV_ORG_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
INV_ORG_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
INV_ORG_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
INV_ORG_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
INV_ORG_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
INV_ORG_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
INV_ORG_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
INV_ORG_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
INV_ORG_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
INV_ORG_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment

Query Text

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


SELECT ORGANIZATION_ID
,      ORGANIZATION_CODE
,      MASTER_ORGANIZATION_CODE
,      CONSIGNED_FLAG
,      WMS_ENABLED_FLAG
,      ORG_PARAM_PPV_ACCOUNT
,      ORG_PARAM_AP_ACCRUAL_ACCOUNT
,      ORG_PARAM_ITR_ACCOUNT
,      ORG_PARAM_IOR_ACCOUNT
,      ORG_PARAM_IOP_ACCOUNT
,      ORG_PARAM_COGS_ACCOUNT
,      ORG_PARAM_XFER_CREDIT_ACCOUNT
,      ORG_PARAM_IPV_ACCOUNT
,      ORG_PARAM_EXPENSE_ACCOUNT
,      ORG_PARAM_DISTR_ACCOUNT_ID
,      ORG_PARAM_DCOGS_ACCOUNT
,      INV_ORG_ATTRIBUTE_CATEGORY
,      INV_ORG_ATTRIBUTE1
,      INV_ORG_ATTRIBUTE2
,      INV_ORG_ATTRIBUTE3
,      INV_ORG_ATTRIBUTE4
,      INV_ORG_ATTRIBUTE5
,      INV_ORG_ATTRIBUTE6
,      INV_ORG_ATTRIBUTE7
,      INV_ORG_ATTRIBUTE8
,      INV_ORG_ATTRIBUTE9
,      INV_ORG_ATTRIBUTE10
,      INV_ORG_ATTRIBUTE11
,      INV_ORG_ATTRIBUTE12
,      INV_ORG_ATTRIBUTE13
,      INV_ORG_ATTRIBUTE14
,      INV_ORG_ATTRIBUTE15
FROM APPS.GMF_XLA_ORG_PARAMETERS_V;

Dependencies

[top of page]

APPS.GMF_XLA_ORG_PARAMETERS_V references the following:

APPS: MTL_PARAMETERS

APPS.GMF_XLA_ORG_PARAMETERS_V is not referenced by any database object