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

VIEW: BOM.CST_REVENUE_COGS_MATCH_LINES#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
COGS_OM_LINE_ID NUMBER
Yes
PAC_COST_TYPE_ID NUMBER

REVENUE_OM_LINE_ID NUMBER
Yes
DEFERRED_COGS_ACCT_ID NUMBER
Yes
COGS_ACCT_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
OPERATING_UNIT_ID NUMBER
Yes
COST_GROUP_ID NUMBER

LEDGER_ID NUMBER
Yes
SALES_ORDER_ISSUE_DATE DATE
Yes
UNIT_MATERIAL_COST NUMBER

UNIT_MOH_COST NUMBER

UNIT_RESOURCE_COST NUMBER

UNIT_OP_COST NUMBER

UNIT_OVERHEAD_COST NUMBER

UNIT_COST NUMBER

ORIGINAL_SHIPPED_QTY NUMBER

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

Query Text

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


SELECT COGS_OM_LINE_ID
,      PAC_COST_TYPE_ID
,      REVENUE_OM_LINE_ID
,      DEFERRED_COGS_ACCT_ID
,      COGS_ACCT_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      OPERATING_UNIT_ID
,      COST_GROUP_ID
,      LEDGER_ID
,      SALES_ORDER_ISSUE_DATE
,      UNIT_MATERIAL_COST
,      UNIT_MOH_COST
,      UNIT_RESOURCE_COST
,      UNIT_OP_COST
,      UNIT_OVERHEAD_COST
,      UNIT_COST
,      ORIGINAL_SHIPPED_QTY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM BOM.CST_REVENUE_COGS_MATCH_LINES#;

Dependencies

[top of page]

BOM.CST_REVENUE_COGS_MATCH_LINES# references the following:

SchemaBOM
TableCST_REVENUE_COGS_MATCH_LINES
BOM.CST_REVENUE_COGS_MATCH_LINES# is referenced by following:

SchemaAPPS
SynonymCST_REVENUE_COGS_MATCH_LINES