DBA Data[Home] [Help]

VIEW: APPS.QPBV_ITEM_UPGRADES

Source

View Text - Preformatted

SELECT LIST_HEADER_ID ,LIST_LINE_NO ,START_DATE_ACTIVE ,END_DATE_ACTIVE ,ESTIM_GL_VALUE ,PRODUCT_PRECEDENCE ,PRICING_PHASE_ID ,INVENTORY_ITEM_ID ,ORGANIZATION_ID ,RELATED_ITEM_ID ,RELATIONSHIP_TYPE_ID ,INCOMPATIBILITY_GRP_CODE ,LIST_LINE_TYPE_CODE ,MODIFIER_LEVEL_CODE ,LIST_LINE_ID ,CREATION_DATE ,CREATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,ORIG_SYS_HEADER_REF ,ORIG_SYS_LINE_REF from qp_list_lines WHERE list_line_type_code = 'IUE'
View Text - HTML Formatted

SELECT LIST_HEADER_ID
, LIST_LINE_NO
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ESTIM_GL_VALUE
, PRODUCT_PRECEDENCE
, PRICING_PHASE_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, RELATED_ITEM_ID
, RELATIONSHIP_TYPE_ID
, INCOMPATIBILITY_GRP_CODE
, LIST_LINE_TYPE_CODE
, MODIFIER_LEVEL_CODE
, LIST_LINE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, ORIG_SYS_HEADER_REF
, ORIG_SYS_LINE_REF
FROM QP_LIST_LINES
WHERE LIST_LINE_TYPE_CODE = 'IUE'