[Home] [Help] [Dependency Information]

VIEW: APPS.QP_LIST_LINES_V

Object Details

Object Name:	QP_LIST_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QP.QP_LIST_LINES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      LIST_LINE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      LIST_HEADER_ID
,      PA_LIST_HEADER_ID
,      PRODUCT_ATTRIBUTE_CONTEXT
,      PRODUCT_ATTRIBUTE
,      PRODUCT_ATTR_VALUE
,      PRODUCT_UOM_CODE
,      LIST_PRICE
,      PERCENT_PRICE
,      PRICE_BY_FORMULA_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PRIMARY_UOM_FLAG
,      REVISION
,      REVISION_DATE
,      REVISION_REASON_CODE
,      COMMENTS
,      LIST_LINE_TYPE_CODE
,      AUTOMATIC_FLAG
,      MODIFIER_LEVEL_CODE
,      LIST_PRICE_UOM_CODE
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      RELATED_ITEM_ID
,      NUMBER_EFFECTIVE_PERIODS
,      EFFECTIVE_PERIOD_UOM
,      ARITHMETIC_OPERATOR
,      INCOMPATIBILITY_GRP_CODE
,      LIST_LINE_NO
,      PRICING_GROUP_SEQUENCE
,      RELATIONSHIP_TYPE_ID
,      SUBSTITUTION_CONTEXT
,      SUBSTITUTION_ATTRIBUTE
,      SUBSTITUTION_VALUE
,      PRICE_BREAK_TYPE_CODE
,      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
,      ACCRUAL_FLAG
,      REPRICE_FLAG
,      PRICING_PHASE_ID
,      PRODUCT_PRECEDENCE
,      CUSTOMER_ITEM_ID
,      PRICING_ATTRIBUTE_CONTEXT
,      PRICING_ATTRIBUTE
,      PRICING_ATTR_VALUE_FROM
,      PRICING_ATTR_VALUE_TO
,      PRODUCT_ATTR_VAL_DISP
,      PRODUCT_ID
,      PRICING_ATTRIBUTE_ID
,      PRODUCT_ATTRIBUTE_DATATYPE
,      PRICING_ATTRIBUTE_DATATYPE
,      COMPARISON_OPERATOR_CODE
,      ATTR_LIST_LINE_ID
,      ATTR_CREATION_DATE
,      ATTR_CREATED_BY
,      ATTR_LAST_UPDATE_DATE
,      ATTR_LAST_UPDATED_BY
,      ATTR_LAST_UPDATE_LOGIN
,      ATTR_PROGRAM_APPLICATION_ID
,      ATTR_PROGRAM_ID
,      ATTR_PROGRAM_UPDATE_DATE
,      ATTR_REQUEST_ID
,      ATTR_CONTEXT
,      ATTR_ATTRIBUTE1
,      ATTR_ATTRIBUTE2
,      ATTR_ATTRIBUTE3
,      ATTR_ATTRIBUTE4
,      ATTR_ATTRIBUTE5
,      ATTR_ATTRIBUTE6
,      ATTR_ATTRIBUTE7
,      ATTR_ATTRIBUTE8
,      ATTR_ATTRIBUTE9
,      ATTR_ATTRIBUTE10
,      ATTR_ATTRIBUTE11
,      ATTR_ATTRIBUTE12
,      ATTR_ATTRIBUTE13
,      ATTR_ATTRIBUTE14
,      ATTR_ATTRIBUTE15
,      BREAK_UOM_CODE
,      BREAK_UOM_CONTEXT
,      BREAK_UOM_ATTRIBUTE
,      CONTINUOUS_PRICE_BREAK_FLAG
FROM APPS.QP_LIST_LINES_V;

Dependencies

[top of page]

APPS

QP_LIST_LINES

QP_PRICE_LIST_LINE_UTIL - show dependent code

QP_PRICING_ATTRIBUTES

APPS

CSD_PROCESS_UTIL - show dependent code

DPP_PRICING_PVT - show dependent code

JAI_AR_SUP_TRX_PKG - show dependent code

JAI_AVLIST_VALIDATE_PKG - show dependent code

JAI_CMN_MTAX_PKG - show dependent code

JAI_CMN_SETUP_PKG - show dependent code

JAI_PO_OSP_PKG - show dependent code

OM_SETUP_VALID_PKG - show dependent code

QP_PRICE_BOOK_PVT - show dependent code