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


VIEW: APPS.QPR_SR_OM_QUOTE_COST_V

Object Details
Object Name: QPR_SR_OM_QUOTE_COST_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.


Order management deal source view - Cost date


[View Source]

Columns
Name Datatype Length Mandatory Comments
QUOTE_HEADER_ID NUMBER
Yes Source header id
QUOTE_LINE_ID NUMBER
Yes Source line id
SOURCE_ID NUMBER

Source id
EROSION_TYPE CHAR (4)
Erosion type
COST_ID CHAR (4)
Cost Id
COST_DESC VARCHAR2 (80)
Cost description
UNIT_COST NUMBER

Cost per unit
TOTAL_COST NUMBER

Total cost
Query Text

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


SELECT QUOTE_HEADER_ID
,      QUOTE_LINE_ID
,      SOURCE_ID
,      EROSION_TYPE
,      COST_ID
,      COST_DESC
,      UNIT_COST
,      TOTAL_COST
FROM APPS.QPR_SR_OM_QUOTE_COST_V;

Dependencies

[top of page]

APPS.QPR_SR_OM_QUOTE_COST_V references the following:

SchemaAPPS
PL/SQL PackageCST_COST_API - show dependent code
ViewFND_APPLICATION_VL
PL/SQL PackageFND_PROFILE - show dependent code
ViewGL_SETS_OF_BOOKS
SynonymHR_ORGANIZATION_INFORMATION
SynonymHZ_CUST_ACCOUNTS
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
ViewQPR_LOOKUPS
PL/SQL PackageQPR_SR_UTIL - show dependent code

APPS.QPR_SR_OM_QUOTE_COST_V is not referenced by any database object