[Home] [Help] [Dependency Information]
Object Name: | QP_PB_INPUT_HEADERS_B |
---|---|
Object Type: | TABLE |
Owner: | QP |
FND Design Data: | QP.QP_PB_INPUT_HEADERS_B |
Subobject Name: | |
Status: | VALID |
Header Record of Price Book Request Input Criteria with non-transalateable columns
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QP_PB_INPUT_HEADERS_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PB_INPUT_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PB_INPUT_HEADER_ID | NUMBER | Yes | Primary Key of the table | |
CUSTOMER_CONTEXT | VARCHAR2 | (30) | Yes | CUSTOMER |
CUSTOMER_ATTRIBUTE | VARCHAR2 | (30) | Yes | QUALIFIER_ATTRIBUTE2 |
CUSTOMER_ATTR_VALUE | VARCHAR2 | (240) | Party Id of Customer | |
DLV_XML_SITE_ID | NUMBER | Party Site Id to which Sync Catalog is sent | ||
CURRENCY_CODE | VARCHAR2 | (30) | Currency of the Price Book | |
LIMIT_PRODUCTS_BY | VARCHAR2 | (30) | Can be ITEM, ITEM_CATEGORY, PRICE_LIST or blank | |
PRODUCT_CONTEXT | VARCHAR2 | (30) | Product Context | |
PRODUCT_ATTRIBUTE | VARCHAR2 | (30) | PRICING_ATTRIBUTE1 for Item Number;PRICING_ATTRIBUTE2 for Item Category | |
PRODUCT_ATTR_VALUE | VARCHAR2 | (240) | Inventory Item Id or Category Id depending on the PRODUCT_ATTRIBUTE column value | |
EFFECTIVE_DATE | DATE | Yes | Pricing Effective Date - Default is sysdate | |
ITEM_QUANTITY | NUMBER | Yes | Default is 1 | |
PUB_TEMPLATE_CODE | VARCHAR2 | (80) | Referenced from the XDO_TEMPLATES_B table | |
PUB_LANGUAGE | VARCHAR2 | (6) | XML Publisher Template Language | |
PUB_TERRITORY | VARCHAR2 | (6) | XML Publisher Template Territory | |
PUB_OUTPUT_DOCUMENT_TYPE | VARCHAR2 | (30) | Indicates the type of output document | |
DLV_XML_FLAG | VARCHAR2 | (1) | SYNC_CATALOG generated if this flag is 'Y' | |
DLV_EMAIL_FLAG | VARCHAR2 | (1) | 'Y' if Pricebook to be sent by email | |
DLV_EMAIL_ADDRESSES | VARCHAR2 | (240) | Relevant if Email Delivery Method is 'Y' | |
DLV_PRINTER_FLAG | VARCHAR2 | (1) | Pricebook is printed if 'Y' | |
DLV_PRINTER_NAME | VARCHAR2 | (80) | Relevant if the Print Delivery method is 'Y' | |
GENERATION_TIME_CODE | VARCHAR2 | (30) | Indicates when to generate the price book - 'IMMEDIATE' or 'SCHEDULE' - Default is 'IMMEDIATE' | |
GEN_SCHEDULE_DATE | DATE | Relevant if GENERATION_TIME_CODE is SCHEDULE | ||
REQUEST_ID | NUMBER | Stores the concurrent request id that processes the input | ||
ORG_ID | NUMBER | For Multi-Org Support.Corresponds to an Operating Unit | ||
PRICE_BOOK_TYPE_CODE | VARCHAR2 | (1) | Yes | F or D (Full/Delta)-Default=F |
PRICE_BASED_ON | VARCHAR2 | (30) | Can be PRICE_LIST, AGREEMENT, BSA or blank | |
PL_AGR_BSA_ID | NUMBER | Refers to a Price list Id, Agreement Id or BSA Id | ||
PRICING_PERSPECTIVE_CODE | VARCHAR2 | (30) | Application short name of the consumer application | |
PUBLISH_EXISTING_PB_FLAG | VARCHAR2 | (1) | If 'Y', an existing pricebook is published | |
OVERWRITE_EXISTING_PB_FLAG | VARCHAR2 | (1) | If 'Y' if an existing Price Book can be overwritten | |
REQUEST_ORIGINATION_CODE | VARCHAR2 | (3) | indicates where the input/request originated from. Valid values are 'XML', 'UI', 'API' (Default) | |
REQUEST_TYPE_CODE | VARCHAR2 | (30) | Yes | Required by Pricing Engine. Derived |
VALIDATION_ERROR_FLAG | VARCHAR2 | (1) | 'Y' indicates messages exists for this Input Header Id | |
CREATION_DATE | DATE | Yes | Std Who Column | |
CUST_ACCOUNT_ID | NUMBER | Customer account id | ||
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 |
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;
QP.QP_PB_INPUT_HEADERS_B does not reference any database object
QP.QP_PB_INPUT_HEADERS_B is referenced by following:
|
|
|