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

VIEW: APPS.CST_LAYER_ACTUAL_COST_DTLS_V

Object Details
Object Name: CST_LAYER_ACTUAL_COST_DTLS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_LAYER_ACTUAL_COST_DTLS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER

ORGANIZATION_ID NUMBER

LAYER_ID NUMBER

INV_LAYER_ID NUMBER

LAYER_QUANTITY NUMBER

TRANSACTION_SOURCE_TYPE_NAME VARCHAR2 (30)
TRANSACTION_SOURCE_TYPE_ID NUMBER

MATERIAL_COST NUMBER

MATERIAL_OVERHEAD_COST NUMBER

RESOURCE_COST NUMBER

OUTSIDE_PROCESSING_COST NUMBER

OVERHEAD_COST NUMBER

TOTAL_UNIT_COST NUMBER

TRANSACTION_SOURCE_ID NUMBER

TRANSACTION_SOURCE_NAME VARCHAR2 (240)
Query Text

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


SELECT TRANSACTION_ID
,      ORGANIZATION_ID
,      LAYER_ID
,      INV_LAYER_ID
,      LAYER_QUANTITY
,      TRANSACTION_SOURCE_TYPE_NAME
,      TRANSACTION_SOURCE_TYPE_ID
,      MATERIAL_COST
,      MATERIAL_OVERHEAD_COST
,      RESOURCE_COST
,      OUTSIDE_PROCESSING_COST
,      OVERHEAD_COST
,      TOTAL_UNIT_COST
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_NAME
FROM APPS.CST_LAYER_ACTUAL_COST_DTLS_V;

Dependencies

[top of page]

APPS.CST_LAYER_ACTUAL_COST_DTLS_V references the following:

SchemaAPPS
SynonymCST_INV_LAYERS
SynonymMTL_CST_LAYER_ACT_COST_DETAILS
SynonymMTL_MATERIAL_TRANSACTIONS
SynonymMTL_TRANSACTION_ACCOUNTS
SynonymMTL_TXN_SOURCE_TYPES

APPS.CST_LAYER_ACTUAL_COST_DTLS_V is not referenced by any database object