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

VIEW: APPS.AMS_PRODUCT_OFFERS_V

Object Details
Object Name: AMS_PRODUCT_OFFERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_PRODUCT_OFFERS_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
NAME VARCHAR2 (240) Yes
DESCRIPTION VARCHAR2 (2000)
REQUEST_ONLY VARCHAR2 (1)
ACTIVE_FLAG VARCHAR2 (1)
OFFER_TYPE VARCHAR2 (30) Yes
REUSABLE VARCHAR2 (1)
OFFER_TYPE_MEANING VARCHAR2 (4000)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

OPERAND NUMBER

PRODUCT_PRECEDENCE NUMBER

PRODUCT_ID VARCHAR2 (240)
OPERATOR VARCHAR2 (4000)
PHASE VARCHAR2 (4000)
INCOMPATIBILITY VARCHAR2 (4000)
DISCOUNT_LEVEL VARCHAR2 (4000)
LINE_TYPE VARCHAR2 (4000)
PRICE_BREAK VARCHAR2 (4000)
UNIT_OF_MEASURE VARCHAR2 (4000)
Query Text

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


SELECT NAME
,      DESCRIPTION
,      REQUEST_ONLY
,      ACTIVE_FLAG
,      OFFER_TYPE
,      REUSABLE
,      OFFER_TYPE_MEANING
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      OPERAND
,      PRODUCT_PRECEDENCE
,      PRODUCT_ID
,      OPERATOR
,      PHASE
,      INCOMPATIBILITY
,      DISCOUNT_LEVEL
,      LINE_TYPE
,      PRICE_BREAK
,      UNIT_OF_MEASURE
FROM APPS.AMS_PRODUCT_OFFERS_V;

Dependencies

[top of page]

APPS.AMS_PRODUCT_OFFERS_V references the following:

SchemaAPPS
PL/SQL PackageAMS_UTILITY_PVT - show dependent code
SynonymOZF_OFFERS
PL/SQL PackageOZF_UTILITY_PVT - show dependent code
ViewQP_LIST_HEADERS_VL
SynonymQP_LIST_LINES
SynonymQP_PRICING_ATTRIBUTES
PL/SQL PackageQP_QP_FORM_PRICING_ATTR - show dependent code

APPS.AMS_PRODUCT_OFFERS_V is not referenced by any database object