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

VIEW: APPS.CST_AVG_DIST_ACCTS_V

Object Details
Object Name: CST_AVG_DIST_ACCTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_AVG_DIST_ACCTS_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
ORGANIZATION_ID NUMBER

Organization identifier
COST_GROUP_ID NUMBER

Cost Group Identifier
MATERIAL_ACCOUNT NUMBER

Inventory material account
MATERIAL_OVERHEAD_ACCOUNT NUMBER

Inventory material overhead account
RESOURCE_ACCOUNT NUMBER

Resource labor account
OVERHEAD_ACCOUNT NUMBER

Overhead account
OUTSIDE_PROCESSING_ACCOUNT NUMBER

Outside processing account
AVERAGE_COST_VAR_ACCOUNT NUMBER

Average cost variance account
ENCUMBRANCE_ACCOUNT NUMBER

Encumbrance account
PAYBACK_MAT_VAR_ACCOUNT NUMBER

borrow payback material variance account
PAYBACK_RES_VAR_ACCOUNT NUMBER

borrow payback resource account
PAYBACK_OSP_VAR_ACCOUNT NUMBER

borrow payback outside processing variance account
PAYBACK_MOH_VAR_ACCOUNT NUMBER

borrow payback material overhead variance account
PAYBACK_OVH_VAR_ACCOUNT NUMBER

borrow payback overhead variance account
Query Text

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


SELECT ORGANIZATION_ID
,      COST_GROUP_ID
,      MATERIAL_ACCOUNT
,      MATERIAL_OVERHEAD_ACCOUNT
,      RESOURCE_ACCOUNT
,      OVERHEAD_ACCOUNT
,      OUTSIDE_PROCESSING_ACCOUNT
,      AVERAGE_COST_VAR_ACCOUNT
,      ENCUMBRANCE_ACCOUNT
,      PAYBACK_MAT_VAR_ACCOUNT
,      PAYBACK_RES_VAR_ACCOUNT
,      PAYBACK_OSP_VAR_ACCOUNT
,      PAYBACK_MOH_VAR_ACCOUNT
,      PAYBACK_OVH_VAR_ACCOUNT
FROM APPS.CST_AVG_DIST_ACCTS_V;

Dependencies

[top of page]

APPS.CST_AVG_DIST_ACCTS_V references the following:

SchemaAPPS
SynonymCST_COST_GROUP_ACCOUNTS
SynonymMTL_PARAMETERS

APPS.CST_AVG_DIST_ACCTS_V is not referenced by any database object