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


VIEW: APPS.AMS_PRICE_LIST_LINES_V

Object Details
Object Name: AMS_PRICE_LIST_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_PRICE_LIST_LINES_V
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
LIST_LINE_ID NUMBER
Yes
LIST_HEADER_ID NUMBER
Yes
PRICING_ATTRIBUTE_ID NUMBER
Yes
INVENTORY_ITEM_ID VARCHAR2 (240)
PRODUCT_PRECEDENCE NUMBER

UNIT_CODE VARCHAR2 (3)
LIST_PRICE NUMBER

START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

PADDED_CONCATENATED_SEGMENTS VARCHAR2 (40)
CONCATENATED_SEGMENTS VARCHAR2 (40)
ITEM_DESCRIPTION VARCHAR2 (240)
COMMENTS VARCHAR2 (2000)
Query Text

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


SELECT LIST_LINE_ID
,      LIST_HEADER_ID
,      PRICING_ATTRIBUTE_ID
,      INVENTORY_ITEM_ID
,      PRODUCT_PRECEDENCE
,      UNIT_CODE
,      LIST_PRICE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      PADDED_CONCATENATED_SEGMENTS
,      CONCATENATED_SEGMENTS
,      ITEM_DESCRIPTION
,      COMMENTS
FROM APPS.AMS_PRICE_LIST_LINES_V;

Dependencies

[top of page]

APPS.AMS_PRICE_LIST_LINES_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymQP_LIST_LINES
SynonymQP_PRICING_ATTRIBUTES

APPS.AMS_PRICE_LIST_LINES_V is not referenced by any database object