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]

VIEW: APPS.QPR_SR_COST_DATA_V

Object Details

Object Name:	QPR_SR_COST_DATA_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Cost measure source view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORD_LEVEL_VALUE	NUMBER		Yes	Order dimension value
BOOKED_DATE	DATE			Time dimension value
COS_LEVEL_VALUE	CHAR	(4)		Cost dimension value
UNIT_LIST_PRICE	NUMBER			Unit list price
UNIT_COST	NUMBER			Unit cost
TOP_MODEL_LINE_ID	NUMBER			Top model line id
LINK_TO_LINE_ID	NUMBER			Linked to line id
ATO_LINE_ID	NUMBER			ATO Line id
ITEM_TYPE_CODE	VARCHAR2	(30)		Item type
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item id
COMPONENT_CODE	VARCHAR2	(1000)		Component code
ORDER_QUANTITY	NUMBER			Ordered quantity

Query Text

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


SELECT ORD_LEVEL_VALUE
,      BOOKED_DATE
,      COS_LEVEL_VALUE
,      UNIT_LIST_PRICE
,      UNIT_COST
,      TOP_MODEL_LINE_ID
,      LINK_TO_LINE_ID
,      ATO_LINE_ID
,      ITEM_TYPE_CODE
,      INVENTORY_ITEM_ID
,      COMPONENT_CODE
,      ORDER_QUANTITY
FROM APPS.QPR_SR_COST_DATA_V;

Dependencies

[top of page]

APPS.QPR_SR_COST_DATA_V references the following:

APPS: CST_COST_API - show dependent code; FND_PROFILE - show dependent code; GL_SETS_OF_BOOKS; HR_ORGANIZATION_INFORMATION; HZ_CUST_ACCOUNTS; MTL_MATERIAL_TRANSACTIONS; MTL_SYSTEM_ITEMS_B; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; QPR_SR_UTIL - show dependent code

APPS.QPR_SR_COST_DATA_V is not referenced by any database object