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

VIEW: APPS.ASO_PVT_HDR_PRICE_ADJ_UI_V

Object Details
Object Name: ASO_PVT_HDR_PRICE_ADJ_UI_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
QUOTE_HEADER_ID NUMBER
Yes Foreign Key from Quote Headers
MODIFIER_HEADER_ID NUMBER

Modifier Header ID from Pricing
MODIFIER_LINE_ID NUMBER

Modifier Line ID from Pricing
ADJUSTED_AMOUNT NUMBER

MODIFIER_LEVEL_CODE VARCHAR2 (30)
ADJUSTMENT VARCHAR2 (240)
LIST_HEADER_ID NUMBER

LIST_LINE_ID NUMBER

APPLIED_FLAG VARCHAR2 (1)
GROUP_NUMBER VARCHAR2 (240) Yes
ADJUSTMENT_GROUP VARCHAR2 (2000)
GROUP_DESCRIPTION VARCHAR2 (2000)
PRICING_GROUP_SEQUENCE NUMBER

SUBSTITUTION_ATTRIBUTE VARCHAR2 (30)
MODIFIER_LINE_TYPE_CODE VARCHAR2 (30)
APPLICATION_METHOD VARCHAR2 (30)
Application method
Query Text

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


SELECT QUOTE_HEADER_ID
,      MODIFIER_HEADER_ID
,      MODIFIER_LINE_ID
,      ADJUSTED_AMOUNT
,      MODIFIER_LEVEL_CODE
,      ADJUSTMENT
,      LIST_HEADER_ID
,      LIST_LINE_ID
,      APPLIED_FLAG
,      GROUP_NUMBER
,      ADJUSTMENT_GROUP
,      GROUP_DESCRIPTION
,      PRICING_GROUP_SEQUENCE
,      SUBSTITUTION_ATTRIBUTE
,      MODIFIER_LINE_TYPE_CODE
,      APPLICATION_METHOD
FROM APPS.ASO_PVT_HDR_PRICE_ADJ_UI_V;

Dependencies

[top of page]

APPS.ASO_PVT_HDR_PRICE_ADJ_UI_V references the following:

SchemaAPPS
SynonymASO_PRICE_ADJUSTMENTS
SynonymASO_QUOTE_LINES
SynonymQP_LIST_HEADERS_B
SynonymQP_LIST_HEADERS_TL

APPS.ASO_PVT_HDR_PRICE_ADJ_UI_V is not referenced by any database object