[Home] [Help] [Dependency Information]

VIEW: APPS.QP_LISTS_V

Object Details

Object Name:	QP_LISTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QP.QP_LISTS_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

Query Text

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

SELECT ROW_ID
,      CURRENCY_CODE
,      SHIP_METHOD_CODE
,      FREIGHT_TERMS_CODE
,      LIST_HEADER_ID
,      CREATION_DATE
,      QPH_START_DATE_ACTIVE
,      QPH_END_DATE_ACTIVE
,      LIST_TYPE_CODE
,      TERMS_ID
,      ROUNDING_FACTOR
,      DISCOUNT_LINES_FLAG
,      NAME
,      DESCRIPTION
,      VERSION_NO
,      COMMENTS
,      GSA_INDICATOR
,      PRORATE_FLAG
,      SOURCE_SYSTEM_CODE
,      ACTIVE_FLAG
,      PARENT_LIST_HEADER_ID
,      START_DATE_ACTIVE_FIRST
,      END_DATE_ACTIVE_FIRST
,      ACTIVE_DATE_FIRST_TYPE
,      START_DATE_ACTIVE_SECOND
,      END_DATE_ACTIVE_SECOND
,      ACTIVE_DATE_SECOND_TYPE
,      ASK_FOR_FLAG
,      LIST_LINE_ID
,      LIST_LINE_TYPE_CODE
,      AUTOMATIC_FLAG
,      MODIFIER_LEVEL_CODE
,      LIST_PRICE
,      PRIMARY_UOM_FLAG
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      RELATED_ITEM_ID
,      RELATIONSHIP_TYPE_ID
,      SUBSTITUTION_CONTEXT
,      SUBSTITUTION_ATTRIBUTE
,      SUBSTITUTION_VALUE
,      REVISION
,      REVISION_DATE
,      REVISION_REASON_CODE
,      PRICE_BREAK_TYPE_CODE
,      PERCENT_PRICE
,      PRICE_BY_FORMULA_ID
,      NUMBER_EFFECTIVE_PERIODS
,      EFFECTIVE_PERIOD_UOM
,      ARITHMETIC_OPERATOR
,      OPERAND
,      OVERRIDE_FLAG
,      PRINT_ON_INVOICE_FLAG
,      REBATE_TRANSACTION_TYPE_CODE
,      BASE_QTY
,      BASE_UOM_CODE
,      ACCRUAL_QTY
,      ACCRUAL_UOM_CODE
,      ESTIM_ACCRUAL_RATE
,      GENERATE_USING_FORMULA_ID
,      QPL_START_DATE_ACTIVE
,      QPL_END_DATE_ACTIVE
,      REPRICE_FLAG
,      ACCRUAL_FLAG
,      PRICING_GROUP_SEQUENCE
,      INCOMPATIBILITY_GRP_CODE
,      LIST_LINE_NO
,      PRICING_PHASE_ID
,      PRODUCT_PRECEDENCE
,      LIST_PRICE_UOM_CODE
,      EXPIRATION_PERIOD_START_DATE
,      NUMBER_EXPIRATION_PERIODS
,      EXPIRATION_PERIOD_UOM
,      EXPIRATION_DATE
FROM APPS.QP_LISTS_V;

Dependencies

[top of page]

APPS

QP_LIST_HEADERS_VL

QP_LIST_LINES

APPS.QP_LISTS_V is not referenced by any database object