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


VIEW: APPS.QP_LIST_HEADERS_VL

Object Details
Object Name: QP_LIST_HEADERS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewQP.QP_LIST_HEADERS_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
CURRENCY_CODE VARCHAR2 (30)
SHIP_METHOD_CODE VARCHAR2 (30)
FREIGHT_TERMS_CODE VARCHAR2 (30)
LIST_HEADER_ID NUMBER
Yes
CREATION_DATE DATE
Yes
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

AUTOMATIC_FLAG VARCHAR2 (1)
LIST_TYPE_CODE VARCHAR2 (30) Yes
TERMS_ID NUMBER

ROUNDING_FACTOR NUMBER

REQUEST_ID NUMBER

CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

DISCOUNT_LINES_FLAG VARCHAR2 (1)
NAME VARCHAR2 (240) Yes
DESCRIPTION VARCHAR2 (2000)
VERSION_NO VARCHAR2 (30)
COMMENTS VARCHAR2 (2000)
GSA_INDICATOR VARCHAR2 (1)
PRORATE_FLAG VARCHAR2 (30)
SOURCE_SYSTEM_CODE VARCHAR2 (30)
ASK_FOR_FLAG VARCHAR2 (1)
PARENT_LIST_HEADER_ID NUMBER

START_DATE_ACTIVE_FIRST DATE

END_DATE_ACTIVE_FIRST DATE

ACTIVE_DATE_FIRST_TYPE VARCHAR2 (30)
START_DATE_ACTIVE_SECOND DATE

END_DATE_ACTIVE_SECOND DATE

ACTIVE_DATE_SECOND_TYPE VARCHAR2 (30)
ACTIVE_FLAG VARCHAR2 (1)
CURRENCY_HEADER_ID NUMBER

PTE_CODE VARCHAR2 (30)
LIST_SOURCE_CODE VARCHAR2 (30)
ORIG_SYSTEM_HEADER_REF VARCHAR2 (50)
GLOBAL_FLAG VARCHAR2 (1)
ORIG_ORG_ID NUMBER

VIEW_FLAG CHAR (1)
UPDATE_FLAG CHAR (1)
MOBILE_DOWNLOAD VARCHAR2 (1)
SHAREABLE_FLAG VARCHAR2 (1)
SOLD_TO_ORG_ID NUMBER

LIMIT_EXISTS_FLAG VARCHAR2 (1)
LOCKED_FROM_LIST_HEADER_ID NUMBER

Query Text

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


SELECT ROW_ID
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CURRENCY_CODE
,      SHIP_METHOD_CODE
,      FREIGHT_TERMS_CODE
,      LIST_HEADER_ID
,      CREATION_DATE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      AUTOMATIC_FLAG
,      LIST_TYPE_CODE
,      TERMS_ID
,      ROUNDING_FACTOR
,      REQUEST_ID
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DISCOUNT_LINES_FLAG
,      NAME
,      DESCRIPTION
,      VERSION_NO
,      COMMENTS
,      GSA_INDICATOR
,      PRORATE_FLAG
,      SOURCE_SYSTEM_CODE
,      ASK_FOR_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
,      ACTIVE_FLAG
,      CURRENCY_HEADER_ID
,      PTE_CODE
,      LIST_SOURCE_CODE
,      ORIG_SYSTEM_HEADER_REF
,      GLOBAL_FLAG
,      ORIG_ORG_ID
,      VIEW_FLAG
,      UPDATE_FLAG
,      MOBILE_DOWNLOAD
,      SHAREABLE_FLAG
,      SOLD_TO_ORG_ID
,      LIMIT_EXISTS_FLAG
,      LOCKED_FROM_LIST_HEADER_ID
FROM APPS.QP_LIST_HEADERS_VL;

Dependencies

[top of page]

APPS.QP_LIST_HEADERS_VL references the following:

SchemaAPPS
SynonymQP_LIST_HEADERS_B
SynonymQP_LIST_HEADERS_TL
APPS.QP_LIST_HEADERS_VL is referenced by following:

SchemaAPPS
Package BodyAHL_VWP_RULES_PVT - show dependent code
Package BodyAHL_VWP_TASK_CST_PR_PVT - show dependent code
Package BodyAHL_VWP_VISIT_CST_PR_PVT - show dependent code
Package BodyAMS_APPROVAL_PVT - show dependent code
ViewAMS_ASO_CAMPAIGN_OFFERS_V
Package BodyAMS_FULFILL_PVT - show dependent code
ViewAMS_OFFERS_V
ViewAMS_PRICE_LISTS_V
ViewAMS_PRODUCT_OFFERS_V
ViewAMS_P_CAMPAIGN_OFFERS_V
ViewAMS_P_OFFER_MKT_SEGMENTS_V
ViewAMS_P_OFFER_PRODUCTS_V
ViewAMS_P_OSO_SOURCE_CODES_V
ViewAMS_P_SOURCE_CODES_V
ViewAMS_SOURCE_CODES_DETAILS_V
Package BodyAMS_SYNC_CALENDAR_PVT - show dependent code
Package BodyAMS_UTILITY_PVT - show dependent code
Package BodyASO_COPY_QUOTE_PVT - show dependent code
Package BodyASO_QUOTE_HEADERS_PVT - show dependent code
ViewAST_EV_HIS_PER_V
ViewAST_OFFER_ONLY_V
ViewBIM_DIMV_OFFERS
Package BodyCSD_CHARGE_LINE_UTIL - show dependent code
Package BodyCST_PL_IMPORT - show dependent code
Package BodyCS_SERVICEREQUEST_UTIL - show dependent code
Package BodyIBE_SHOP_LIST_PVT - show dependent code
ViewMSD_SR_PRICE_LIST_V
Package BodyOE_BLANKET_HEADER_SECURITY - show dependent code
Package BodyOE_BLANKET_UTIL - show dependent code
Package BodyOE_BULK_CACHE - show dependent code
Package BodyOE_BULK_PRICEORDER_PVT - show dependent code
Package BodyOE_BULK_VALIDATE - show dependent code
Package BodyOE_BULK_VALUE_TO_ID - show dependent code
Package BodyOE_CHARGE_PVT - show dependent code
Package BodyOE_CNCL_VALIDATE - show dependent code
Package BodyOE_CNCL_VALIDATE_ADJ - show dependent code
Package BodyOE_CNCL_VALIDATE_HEADER - show dependent code
Package BodyOE_CNCL_VALIDATE_LINE - show dependent code
Package BodyOE_CNCL_VALUE_TO_ID - show dependent code
Package BodyOE_HEADER_SECURITY - show dependent code
Package BodyOE_HOLDS_PVT - show dependent code
Package BodyOE_ID_TO_VALUE - show dependent code
Package BodyOE_LINE_SECURITY - show dependent code
Package BodyOE_OE_AVAILABILITY - show dependent code
Package BodyOE_OE_PRICING_AVAILABILITY - show dependent code
Package BodyOE_ORDER_ADJ_PVT - show dependent code
Package BodyOE_ORDER_CACHE - show dependent code
Package BodyOE_ORDER_IMPORT_SPECIFIC_PVT - show dependent code
Package BodyOE_ORDER_PRICE_PVT - show dependent code
Package BodyOE_PRICE_LIST_UTIL - show dependent code
Package BodyOE_PRICE_ORDER_PVT - show dependent code
Package BodyOE_PRICE_ORDER_PVT_OBSOLETE - show dependent code
Package BodyOE_PRICING_CONT_PVT - show dependent code
Package BodyOE_RELATED_ITEMS_PVT - show dependent code
Package BodyOE_VALIDATE_ADJ - show dependent code
Package BodyOE_VALIDATE_HEADER - show dependent code
Package BodyOE_VALIDATE_LINE - show dependent code
Package BodyOE_VALUE_TO_ID - show dependent code
Package BodyOKS_IMPORT_TEST_INSERT - show dependent code
Package BodyOKS_QP_PKG - show dependent code
Package BodyONT_FREIGHT_UTIL - show dependent code
Package BodyOZF_ADJUSTMENT_EXT_PVT - show dependent code
ViewOZF_AEL_GL_UTL_V
Package BodyOZF_AUTOPAY_PVT - show dependent code
ViewOZF_FUND_CHECKBOOK_V
Package BodyOZF_OFFERADJ_APPROVAL_PVT - show dependent code
ViewOZF_OFFERS_V
Package BodyOZF_OFFER_ADJ_LINE_PVT - show dependent code
ViewOZF_OFFER_CLOB_V
Package BodyOZF_PRE_PROCESS_PVT - show dependent code
Package BodyOZF_PRICELIST_PVT - show dependent code
ViewOZF_PRICE_LISTS_V
ViewOZF_PRODUCT_OFFERS_V
ViewOZF_P_CAMPAIGN_OFFERS_V
Package BodyOZF_UTILITY_PVT - show dependent code
ViewQPR_SR_ADJ_HIER_V
ViewQPR_SR_OM_QUOTE_ADJS_V
ViewQPR_SR_QUOTE_ADJS_V
Package BodyQP_BULK_UTIL - show dependent code
ViewQP_CRMINTEG_PRICELIST_V
Package BodyQP_DELAYED_REQUESTS_UTIL - show dependent code
ViewQP_HDR_LVL_QUAL_V
Package BodyQP_ID_TO_VALUE - show dependent code
Package BodyQP_LIMIT_BALANCE_CHECK_PVT - show dependent code
ViewQP_LINE_LVL_QUAL_V
ViewQP_LISTS_V
ViewQP_LIST_ATTRIBUTES_V
SynonymQP_LIST_HEADERS
ViewQP_PRICELISTS_LOV_V
Package BodyQP_PRICE_BOOK_PVT - show dependent code
Package BodyQP_PRICE_BOOK_UTIL - show dependent code
Package BodyQP_PRICE_FORMULA_UPG_UTIL_PVT - show dependent code
ViewQP_PRICE_LISTS_V
Package BodyQP_QPXPACRL_XMLP_PKG - show dependent code
Package BodyQP_QPXPRFOR_XMLP_PKG - show dependent code
Package BodyQP_QPXPRMLS_XMLP_PKG - show dependent code
Package BodyQP_QUALIFIERS_UTIL - show dependent code
Package BodyQP_RESOLVE_INCOMPATABILITY_PVT - show dependent code
Package BodyQP_UTIL_PUB - show dependent code
ViewXNB_ORDER_LINES_V