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: QP.QP_PB_INPUT_HEADERS_B#

Object Details

Object Name:	QP_PB_INPUT_HEADERS_B#
Object Type:	VIEW
Owner:	QP
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PB_INPUT_HEADER_ID	NUMBER		Yes
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)
CREATION_DATE	DATE		Yes
CUST_ACCOUNT_ID	NUMBER
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER

Query Text

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


SELECT PB_INPUT_HEADER_ID
,      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
,      CREATION_DATE
,      CUST_ACCOUNT_ID
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM QP.QP_PB_INPUT_HEADERS_B#;

Dependencies

[top of page]

QP.QP_PB_INPUT_HEADERS_B# references the following:

QP: QP_PB_INPUT_HEADERS_B

QP.QP_PB_INPUT_HEADERS_B# is referenced by following:

APPS: QP_PB_INPUT_HEADERS_B