eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.QP_PB_INPUT_HEADERS_VL

Object Details

Object Name:	QP_PB_INPUT_HEADERS_VL
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

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

Translated view for qp_pb_input_headers_b and qp_pb_input_headers_tl

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
PB_INPUT_HEADER_ID	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
CUSTOMER_CONTEXT	VARCHAR2	(30)	Yes
CUSTOMER_ATTRIBUTE	VARCHAR2	(30)	Yes
CUSTOMER_ATTR_VALUE	VARCHAR2	(240)
DLV_XML_SITE_ID	NUMBER
CURRENCY_CODE	VARCHAR2	(30)
LIMIT_PRODUCTS_BY	VARCHAR2	(30)
PRODUCT_CONTEXT	VARCHAR2	(30)
PRODUCT_ATTRIBUTE	VARCHAR2	(30)
PRODUCT_ATTR_VALUE	VARCHAR2	(240)
EFFECTIVE_DATE	DATE		Yes
ITEM_QUANTITY	NUMBER		Yes
PUB_TEMPLATE_CODE	VARCHAR2	(80)
PUB_LANGUAGE	VARCHAR2	(6)
PUB_TERRITORY	VARCHAR2	(6)
PUB_OUTPUT_DOCUMENT_TYPE	VARCHAR2	(30)
DLV_XML_FLAG	VARCHAR2	(1)
DLV_EMAIL_FLAG	VARCHAR2	(1)
DLV_EMAIL_ADDRESSES	VARCHAR2	(240)
DLV_PRINTER_FLAG	VARCHAR2	(1)
DLV_PRINTER_NAME	VARCHAR2	(80)
GENERATION_TIME_CODE	VARCHAR2	(30)
GEN_SCHEDULE_DATE	DATE
REQUEST_ID	NUMBER
ORG_ID	NUMBER
PRICE_BOOK_TYPE_CODE	VARCHAR2	(1)	Yes
PRICE_BASED_ON	VARCHAR2	(30)
PL_AGR_BSA_ID	NUMBER
PRICING_PERSPECTIVE_CODE	VARCHAR2	(30)
PUBLISH_EXISTING_PB_FLAG	VARCHAR2	(1)
OVERWRITE_EXISTING_PB_FLAG	VARCHAR2	(1)
REQUEST_ORIGINATION_CODE	VARCHAR2	(3)
REQUEST_TYPE_CODE	VARCHAR2	(30)	Yes
VALIDATION_ERROR_FLAG	VARCHAR2	(1)
PRICE_BOOK_NAME	VARCHAR2	(240)
PL_AGR_BSA_NAME	VARCHAR2	(240)
PUB_TEMPLATE_NAME	VARCHAR2	(240)
CUST_ACCOUNT_ID	NUMBER
LANGUAGE	VARCHAR2	(4)	Yes
SOURCE_LANG	VARCHAR2	(4)	Yes

Query Text

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


SELECT ROW_ID
,      PB_INPUT_HEADER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CUSTOMER_CONTEXT
,      CUSTOMER_ATTRIBUTE
,      CUSTOMER_ATTR_VALUE
,      DLV_XML_SITE_ID
,      CURRENCY_CODE
,      LIMIT_PRODUCTS_BY
,      PRODUCT_CONTEXT
,      PRODUCT_ATTRIBUTE
,      PRODUCT_ATTR_VALUE
,      EFFECTIVE_DATE
,      ITEM_QUANTITY
,      PUB_TEMPLATE_CODE
,      PUB_LANGUAGE
,      PUB_TERRITORY
,      PUB_OUTPUT_DOCUMENT_TYPE
,      DLV_XML_FLAG
,      DLV_EMAIL_FLAG
,      DLV_EMAIL_ADDRESSES
,      DLV_PRINTER_FLAG
,      DLV_PRINTER_NAME
,      GENERATION_TIME_CODE
,      GEN_SCHEDULE_DATE
,      REQUEST_ID
,      ORG_ID
,      PRICE_BOOK_TYPE_CODE
,      PRICE_BASED_ON
,      PL_AGR_BSA_ID
,      PRICING_PERSPECTIVE_CODE
,      PUBLISH_EXISTING_PB_FLAG
,      OVERWRITE_EXISTING_PB_FLAG
,      REQUEST_ORIGINATION_CODE
,      REQUEST_TYPE_CODE
,      VALIDATION_ERROR_FLAG
,      PRICE_BOOK_NAME
,      PL_AGR_BSA_NAME
,      PUB_TEMPLATE_NAME
,      CUST_ACCOUNT_ID
,      LANGUAGE
,      SOURCE_LANG
FROM APPS.QP_PB_INPUT_HEADERS_VL;

Dependencies

[top of page]

APPS.QP_PB_INPUT_HEADERS_VL references the following:

APPS: QP_PB_INPUT_HEADERS_B; QP_PB_INPUT_HEADERS_TL

APPS.QP_PB_INPUT_HEADERS_VL is referenced by following:

APPS: QP_PRICE_BOOK_PUB - show dependent code; QP_PRICE_BOOK_PVT - show dependent code; QP_PRICE_BOOK_UTIL - show dependent code; QP_PRICE_BOOK_UTIL - show dependent code