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

VIEW: BOM.CST_COST_GROUP_ACCOUNTS#

Object Details
Object Name: CST_COST_GROUP_ACCOUNTS#
Object Type: VIEW
Owner: BOM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
COST_GROUP_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

MATERIAL_ACCOUNT NUMBER

MATERIAL_OVERHEAD_ACCOUNT NUMBER

RESOURCE_ACCOUNT NUMBER

OVERHEAD_ACCOUNT NUMBER

OUTSIDE_PROCESSING_ACCOUNT NUMBER

AVERAGE_COST_VAR_ACCOUNT NUMBER

ENCUMBRANCE_ACCOUNT NUMBER

PAYBACK_MAT_VAR_ACCOUNT NUMBER

PAYBACK_RES_VAR_ACCOUNT NUMBER

PAYBACK_OSP_VAR_ACCOUNT NUMBER

PAYBACK_MOH_VAR_ACCOUNT NUMBER

PAYBACK_OVH_VAR_ACCOUNT NUMBER

EXPENSE_ACCOUNT NUMBER

PURCHASE_PRICE_VAR_ACCOUNT NUMBER

Query Text

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


SELECT COST_GROUP_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      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
,      EXPENSE_ACCOUNT
,      PURCHASE_PRICE_VAR_ACCOUNT
FROM BOM.CST_COST_GROUP_ACCOUNTS#;

Dependencies

[top of page]

BOM.CST_COST_GROUP_ACCOUNTS# references the following:

SchemaBOM
TableCST_COST_GROUP_ACCOUNTS
BOM.CST_COST_GROUP_ACCOUNTS# is referenced by following:

SchemaAPPS
SynonymCST_COST_GROUP_ACCOUNTS