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

TABLE: QP.QP_PB_INPUT_HEADERS_TL

Object Details
Object Name: QP_PB_INPUT_HEADERS_TL
Object Type: TABLE
Owner: QP
FND Design Data: TableQP.QP_PB_INPUT_HEADERS_TL
Subobject Name:
Status: VALID


Header Record of Price Book Request Input Criteria with transalateable columns


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QP_PB_INPUT_HEADERS_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPB_INPUT_HEADER_ID
ColumnLANGUAGE
QP_PB_INPUT_HEADERS_TL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICE_BOOK_NAME
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
PB_INPUT_HEADER_ID NUMBER
Yes Primary Key of the table
PRICE_BOOK_NAME VARCHAR2 (240)
Price Book name
PL_AGR_BSA_NAME VARCHAR2 (240)
Price List Name or Agreement Name or BSA Number
PUB_TEMPLATE_NAME VARCHAR2 (240)
XML Publisher Template Name
CREATION_DATE DATE
Yes Std Who Column
CREATED_BY NUMBER
Yes Std Who Column
LAST_UPDATE_DATE DATE
Yes Std Who Column
LAST_UPDATED_BY NUMBER
Yes Std Who Column
LAST_UPDATE_LOGIN NUMBER

Std Who Column
LANGUAGE VARCHAR2 (4) Yes For Translation purpose
SOURCE_LANG VARCHAR2 (4) Yes For Translation purpose
Query Text

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


SELECT PB_INPUT_HEADER_ID
,      PRICE_BOOK_NAME
,      PL_AGR_BSA_NAME
,      PUB_TEMPLATE_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LANGUAGE
,      SOURCE_LANG
FROM QP.QP_PB_INPUT_HEADERS_TL;

Dependencies

[top of page]

QP.QP_PB_INPUT_HEADERS_TL does not reference any database object

QP.QP_PB_INPUT_HEADERS_TL is referenced by following:

SchemaQP
ViewQP_PB_INPUT_HEADERS_TL#