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]

TABLE: BOM.CST_MARGIN_SUMMARY

Object Details

Object Name:	CST_MARGIN_SUMMARY
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.CST_MARGIN_SUMMARY
Subobject Name:
Status:	VALID

CST_MARGIN_TEMP temporarily stores the detailed information that is
used to build Margin Analysis Reports. Like CST_MARGIN_BUILD, Margin
Analysis Load Run and Purge Margin Analysis Load Run requests populate
and remove records from this table.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_MARGIN_SUMMARY_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SOURCE LEGAL_ENTITY_ID ORDER_NUMBER
CST_MARGIN_SUMMARY_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	BUILD_ID ORG_ID SOURCE ROW_TYPE LINK_TO_LINE_ID
CST_MARGIN_SUMMARY_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	RMA_HEADER_ID RMA_LINE_ID BUILD_ID ORG_ID SOURCE
CST_MARGIN_SUMMARY_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	GL_DATE LEGAL_ENTITY_ID
CST_MARGIN_SUMMARY_N5	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORG_ID SOURCE HEADER_ID LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LEGAL_ENTITY_ID	NUMBER			Legal Entity Identifier
BUILD_ID	NUMBER		Yes	Build identifier
SOURCE	VARCHAR2	(15)	Yes	Identifies source of the record
ROW_TYPE	NUMBER		Yes	Identifies the type of a sales order line
ORIGIN	NUMBER		Yes	Identifies the origin of the record
INVOICE_SOURCE	VARCHAR2	(30)		Source of the invoice
PARENT_ROWID	ROWID	(10)		Identifier of SO_ORDER_LINES
ORDER_NUMBER	NUMBER			Order number of the sales order
ORG_ID	NUMBER			Operating unit
HEADER_ID	NUMBER			Order header identifier
ORDER_TYPE_ID	NUMBER			Order type identifier
CUSTOMER_ID	NUMBER			Customer identifier
SOLD_TO_CUSTOMER_NAME	VARCHAR2	(50)		Customer name based on customer identifier
PRIMARY_SALESREP_ID	NUMBER			Primary sales representative identifier
SALES_CHANNEL_CODE	VARCHAR2	(30)		Sales channel code identifier
PARENT_INVENTORY_ITEM_ID	NUMBER			Parent inventory item identifier in case of a non-standard item
PARENT_ORGANIZATION_ID	NUMBER			Organization identifier for the parent item
PARENT_LINE_ID	NUMBER			Line identifier for the parent line
PARENT_LINE_NUMBER	NUMBER			Line number for the parent line
PARENT_ITEM_TYPE_CODE	VARCHAR2	(30)		Type identifier of the parent item, i.e. Standard, Model, Class, etc.
PARENT_ATO_FLAG	VARCHAR2	(1)		Flag indicating if the order line is for ATO
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier for the child line
ORGANIZATION_ID	NUMBER			Organization identifier for the child line
LINE_ID	NUMBER			Line identifier for the child line
LINE_TYPE_CODE	VARCHAR2	(30)		Line type code for the child line
LINE_NUMBER	NUMBER			Line number for the child line
SHIP_TO_SITE_USE_ID	NUMBER			Ship to site identifier
SHIP_TO_CUSTOMER_NAME	VARCHAR2	(50)		Customer name based on SHIP_TO_SITE_USE_ID
INVOICE_TO_SITE_USE_ID	NUMBER			Site identifier for the invoiced site information
BILL_TO_CUSTOMER_NAME	VARCHAR2	(50)		Customer name based on the INVOICE_TO_SITE_USE_ID
CUSTOMER_TRX_ID	NUMBER			Identifier for RA_CUSTOMER_TRX
CUSTOMER_TRX_LINE_ID	NUMBER			Identifier for RA_CUSTOMER_TRX_LINES
ORIGINAL_GL_DATE	DATE			Original General ledger Date
GL_DATE	DATE			General ledger date
INVOICE_LINE_QUANTITY	NUMBER			Quantity invoiced for entire order line
INVOICE_QUANTITY	NUMBER			Quantity invoiced for invoice line
ORDER_LINE_QUANTITY	NUMBER			Order quantity for order line
SHIP_QUANTITY	NUMBER			Actual shipment quantity
INVOICED_AMOUNT	NUMBER			Invoiced amount
COGS_AMOUNT	NUMBER			Cost of goods sold amount
SALES_ACCOUNT	NUMBER			Sales account identifier
COGS_ACCOUNT	NUMBER			Cost of goods sold identifier
TERRITORY_ID	NUMBER			Territory identifier
CUSTOMER_CLASS_CODE	VARCHAR2	(30)		Industry identifier
MARGIN	NUMBER			Margin
MARGIN_PCT	NUMBER			Margin percentage
RETURN_REFERENCE_TYPE_CODE	VARCHAR2	(30)		Return reference type identifier for the RMA lines
RETURN_REFERENCE_ID	NUMBER			Return reference identifier for the RMA lines
LINK_TO_LINE_ID	NUMBER			Parent line identifier if RETURN_REFERENCE_TYPE_CODE is populated
RMA_HEADER_ID	NUMBER			Header identifier for the RMA lines
RMA_NUMBER	NUMBER			Order number for the RMA lines
RMA_INVENTORY_ITEM_ID	NUMBER			Inventory item identifier for the RMA lines
RMA_LINE_ID	NUMBER			Line identifier for the RMA lines
RMA_LINE_NUMBER	NUMBER			Line number for the RMA lines
RMA_ORGANIZATION_ID	NUMBER			Organization identifier for the RMA lines
RMA_LINE_TYPE_CODE	VARCHAR2	(30)		Line type code for the RMA lines
RMA_SHIP_TO_SITE_USE_ID	NUMBER			Site identifier for the shipped site for the RMA lines
RMA_INVOICE_INVENTORY_ITEM_ID	NUMBER			Invoiced inventory item identifier for the RMA lines
CR_TRX_ID	NUMBER			Credit memo identifier in RA_CUSTOMER_TRX
CR_TRX_LINE_ID	NUMBER			Credit memo Identifier in RA_CUSTOMER_TRX_LINES
PERIOD_NAME_YEAR	VARCHAR2	(15)		Year name from General Ledger Periods
PERIOD_NUM_YEAR	NUMBER			Number identifier of Year in General Ledger Period
PERIOD_NAME_QTR	VARCHAR2	(15)		Quarter name from General Ledger Periods
PERIOD_NUM_QTR	NUMBER			Number identifier of Quarter in General Ledger Period
PERIOD_SEQ_QTR	NUMBER			Sequence of General Ledger Period Quarter
PERIOD_NAME_MONTH	VARCHAR2	(15)		Month name from General Ledger Periods
PERIOD_NUM_MONTH	NUMBER			Number identifier of Month in General Ledger Period
PERIOD_SEQ_MONTH	NUMBER			Sequence of General Ledger Period Month
OE_ITEM_CATEGORY_ID	NUMBER			Item Category Identifier based on the default category set of the OE functional area
AREA_CODE	VARCHAR2	(30)		Identifier of Area level of the BIS geography dimension
COUNTRY_CODE	VARCHAR2	(2)		Identifier of Country level of the BIS geography dimension
REGION_CODE	VARCHAR2	(30)		Identifier of Region level of the BIS geography dimension
AREA_NAME	VARCHAR2	(80)		Name of Area level of the BIS geography dimension
COUNTRY_NAME	VARCHAR2	(80)		Name of Country level of the BIS geography dimension
REGION_NAME	VARCHAR2	(80)		Name of Region level of the BIS geography dimension
OPERATING_UNIT_NAME	VARCHAR2	(240)		Name of Operating Unit

Query Text

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


SELECT LEGAL_ENTITY_ID
,      BUILD_ID
,      SOURCE
,      ROW_TYPE
,      ORIGIN
,      INVOICE_SOURCE
,      PARENT_ROWID
,      ORDER_NUMBER
,      ORG_ID
,      HEADER_ID
,      ORDER_TYPE_ID
,      CUSTOMER_ID
,      SOLD_TO_CUSTOMER_NAME
,      PRIMARY_SALESREP_ID
,      SALES_CHANNEL_CODE
,      PARENT_INVENTORY_ITEM_ID
,      PARENT_ORGANIZATION_ID
,      PARENT_LINE_ID
,      PARENT_LINE_NUMBER
,      PARENT_ITEM_TYPE_CODE
,      PARENT_ATO_FLAG
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      LINE_ID
,      LINE_TYPE_CODE
,      LINE_NUMBER
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_CUSTOMER_NAME
,      INVOICE_TO_SITE_USE_ID
,      BILL_TO_CUSTOMER_NAME
,      CUSTOMER_TRX_ID
,      CUSTOMER_TRX_LINE_ID
,      ORIGINAL_GL_DATE
,      GL_DATE
,      INVOICE_LINE_QUANTITY
,      INVOICE_QUANTITY
,      ORDER_LINE_QUANTITY
,      SHIP_QUANTITY
,      INVOICED_AMOUNT
,      COGS_AMOUNT
,      SALES_ACCOUNT
,      COGS_ACCOUNT
,      TERRITORY_ID
,      CUSTOMER_CLASS_CODE
,      MARGIN
,      MARGIN_PCT
,      RETURN_REFERENCE_TYPE_CODE
,      RETURN_REFERENCE_ID
,      LINK_TO_LINE_ID
,      RMA_HEADER_ID
,      RMA_NUMBER
,      RMA_INVENTORY_ITEM_ID
,      RMA_LINE_ID
,      RMA_LINE_NUMBER
,      RMA_ORGANIZATION_ID
,      RMA_LINE_TYPE_CODE
,      RMA_SHIP_TO_SITE_USE_ID
,      RMA_INVOICE_INVENTORY_ITEM_ID
,      CR_TRX_ID
,      CR_TRX_LINE_ID
,      PERIOD_NAME_YEAR
,      PERIOD_NUM_YEAR
,      PERIOD_NAME_QTR
,      PERIOD_NUM_QTR
,      PERIOD_SEQ_QTR
,      PERIOD_NAME_MONTH
,      PERIOD_NUM_MONTH
,      PERIOD_SEQ_MONTH
,      OE_ITEM_CATEGORY_ID
,      AREA_CODE
,      COUNTRY_CODE
,      REGION_CODE
,      AREA_NAME
,      COUNTRY_NAME
,      REGION_NAME
,      OPERATING_UNIT_NAME
FROM BOM.CST_MARGIN_SUMMARY;

Dependencies

[top of page]

BOM.CST_MARGIN_SUMMARY does not reference any database object

BOM.CST_MARGIN_SUMMARY is referenced by following:

APPS: CST_MARGIN_SUMMARY