VIEW: APPS.QP_PB_INPUT_HEADERS_VL

Source

View Text - Preformatted

SELECT B.RowId ROW_ID, B.PB_INPUT_HEADER_ID, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.CUSTOMER_CONTEXT, B.CUSTOMER_ATTRIBUTE, B.CUSTOMER_ATTR_VALUE, B.DLV_XML_SITE_ID, B.CURRENCY_CODE, B.LIMIT_PRODUCTS_BY, B.PRODUCT_CONTEXT, B.PRODUCT_ATTRIBUTE, B.PRODUCT_ATTR_VALUE, B.EFFECTIVE_DATE, B.ITEM_QUANTITY, B.PUB_TEMPLATE_CODE, B.PUB_LANGUAGE, B.PUB_TERRITORY, B.PUB_OUTPUT_DOCUMENT_TYPE, B.DLV_XML_FLAG, B.DLV_EMAIL_FLAG, B.DLV_EMAIL_ADDRESSES, B.DLV_PRINTER_FLAG, B.DLV_PRINTER_NAME, B.GENERATION_TIME_CODE, B.GEN_SCHEDULE_DATE, B.REQUEST_ID, B.ORG_ID, B.PRICE_BOOK_TYPE_CODE, B.PRICE_BASED_ON, B.PL_AGR_BSA_ID, B.PRICING_PERSPECTIVE_CODE, B.PUBLISH_EXISTING_PB_FLAG, B.OVERWRITE_EXISTING_PB_FLAG, B.REQUEST_ORIGINATION_CODE, B.REQUEST_TYPE_CODE, B.VALIDATION_ERROR_FLAG, T.PRICE_BOOK_NAME, T.PL_AGR_BSA_NAME, T.PUB_TEMPLATE_NAME, B.CUST_ACCOUNT_ID, T.LANGUAGE, T.SOURCE_LANG FROM QP_PB_INPUT_HEADERS_B B, QP_PB_INPUT_HEADERS_TL T WHERE B.PB_INPUT_HEADER_ID = T.PB_INPUT_HEADER_ID and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.PB_INPUT_HEADER_ID
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CUSTOMER_CONTEXT
, B.CUSTOMER_ATTRIBUTE
, B.CUSTOMER_ATTR_VALUE
, B.DLV_XML_SITE_ID
, B.CURRENCY_CODE
, B.LIMIT_PRODUCTS_BY
, B.PRODUCT_CONTEXT
, B.PRODUCT_ATTRIBUTE
, B.PRODUCT_ATTR_VALUE
, B.EFFECTIVE_DATE
, B.ITEM_QUANTITY
, B.PUB_TEMPLATE_CODE
, B.PUB_LANGUAGE
, B.PUB_TERRITORY
, B.PUB_OUTPUT_DOCUMENT_TYPE
, B.DLV_XML_FLAG
, B.DLV_EMAIL_FLAG
, B.DLV_EMAIL_ADDRESSES
, B.DLV_PRINTER_FLAG
, B.DLV_PRINTER_NAME
, B.GENERATION_TIME_CODE
, B.GEN_SCHEDULE_DATE
, B.REQUEST_ID
, B.ORG_ID
, B.PRICE_BOOK_TYPE_CODE
, B.PRICE_BASED_ON
, B.PL_AGR_BSA_ID
, B.PRICING_PERSPECTIVE_CODE
, B.PUBLISH_EXISTING_PB_FLAG
, B.OVERWRITE_EXISTING_PB_FLAG
, B.REQUEST_ORIGINATION_CODE
, B.REQUEST_TYPE_CODE
, B.VALIDATION_ERROR_FLAG
, T.PRICE_BOOK_NAME
, T.PL_AGR_BSA_NAME
, T.PUB_TEMPLATE_NAME
, B.CUST_ACCOUNT_ID
, T.LANGUAGE
, T.SOURCE_LANG
FROM QP_PB_INPUT_HEADERS_B B
, QP_PB_INPUT_HEADERS_TL T
WHERE B.PB_INPUT_HEADER_ID = T.PB_INPUT_HEADER_ID
AND T.LANGUAGE = USERENV('LANG')