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_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[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
DLV_XML_FLAG	VARCHAR2	(1)
PUB_TEMPLATE_CODE	VARCHAR2	(80)
PUB_LANGUAGE	VARCHAR2	(6)
PUB_TERRITORY	VARCHAR2	(6)
PUB_OUTPUT_DOCUMENT_TYPE	VARCHAR2	(30)
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)
CUSTOMER_ATTRIBUTE_NAME	VARCHAR2	(4000)
CUSTOMER_NAME	VARCHAR2	(4000)
CURRENCY	VARCHAR2	(4000)
LIMIT_PRODUCTS_BY_NAME	VARCHAR2	(4000)
PRODUCT_ATTRIBUTE_NAME	VARCHAR2	(4000)
PRODUCT_NAME	VARCHAR2	(4000)
GENERATION_TIME	VARCHAR2	(4000)
OPERATING_UNIT	VARCHAR2	(4000)
PRICE_BOOK_TYPE	VARCHAR2	(4000)
PRICE_BASED_ON_NAME	VARCHAR2	(4000)
PRICING_PERSPECTIVE	VARCHAR2	(4000)
PRICE_BOOK_NAME	VARCHAR2	(240)
PL_AGR_BSA_NAME	VARCHAR2	(240)
PUB_TEMPLATE_NAME	VARCHAR2	(240)
LANGUAGE	VARCHAR2	(4)	Yes
SOURCE_LANG	VARCHAR2	(4)	Yes
CUST_ACCOUNT_ID	NUMBER

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
,      DLV_XML_FLAG
,      PUB_TEMPLATE_CODE
,      PUB_LANGUAGE
,      PUB_TERRITORY
,      PUB_OUTPUT_DOCUMENT_TYPE
,      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
,      CUSTOMER_ATTRIBUTE_NAME
,      CUSTOMER_NAME
,      CURRENCY
,      LIMIT_PRODUCTS_BY_NAME
,      PRODUCT_ATTRIBUTE_NAME
,      PRODUCT_NAME
,      GENERATION_TIME
,      OPERATING_UNIT
,      PRICE_BOOK_TYPE
,      PRICE_BASED_ON_NAME
,      PRICING_PERSPECTIVE
,      PRICE_BOOK_NAME
,      PL_AGR_BSA_NAME
,      PUB_TEMPLATE_NAME
,      LANGUAGE
,      SOURCE_LANG
,      CUST_ACCOUNT_ID
FROM APPS.QP_PB_INPUT_HEADERS_V;

Dependencies

[top of page]

APPS.QP_PB_INPUT_HEADERS_V references the following:

APPS: QP_PB_INPUT_HEADERS_B; QP_PB_INPUT_HEADERS_TL; QP_PRICE_BOOK_UTIL - show dependent code

APPS.QP_PB_INPUT_HEADERS_V is not referenced by any database object