VIEW: APPS.QP_PB_INPUT_HEADERS_V

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.DLV_XML_FLAG, B.PUB_TEMPLATE_CODE, B.PUB_LANGUAGE , B.PUB_TERRITORY , B.PUB_OUTPUT_DOCUMENT_TYPE, 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, QP_Price_Book_Util.get_attribute_name(B.CUSTOMER_CONTEXT,B.CUSTOMER_ATTRIBUTE,'QUALIFIER') CUSTOMER_ATTRIBUTE_NAME, QP_Price_Book_Util.get_customer_value(B.CUSTOMER_ATTRIBUTE,B.CUSTOMER_ATTR_VALUE) CUSTOMER_NAME, QP_Price_Book_Util.get_currency_name(B.CURRENCY_CODE) CURRENCY, QP_Price_Book_Util.value_to_meaning(B.LIMIT_PRODUCTS_BY,'PB_PRODUCT_CRITERIA_LIMIT_BY') LIMIT_PRODUCTS_BY_NAME, QP_Price_Book_Util.get_attribute_name(B.PRODUCT_CONTEXT,B.PRODUCT_ATTRIBUTE,'PRODUCT') PRODUCT_ATTRIBUTE_NAME, QP_Price_Book_Util.get_product_value(B.PRODUCT_ATTRIBUTE ,B.PRODUCT_ATTR_VALUE,B.ORG_ID) PRODUCT_NAME, QP_Price_Book_Util.value_to_meaning(B.GENERATION_TIME_CODE,'QP_GEN_TIME_CODE') GENERATION_TIME, QP_Price_Book_Util.get_operating_unit(B.ORG_ID) OPERATING_UNIT, QP_Price_Book_Util.value_to_meaning(B.PRICE_BOOK_TYPE_CODE,'PRICE_BOOK_TYPE_CODE') PRICE_BOOK_TYPE, QP_Price_Book_Util.value_to_meaning(B.PRICE_BASED_ON,'PB_CALCULATION_BASED_ON') PRICE_BASED_ON_NAME, QP_Price_Book_Util.value_to_meaning(B.PRICING_PERSPECTIVE_CODE,'QP_PRICING_PERSPECTIVE') PRICING_PERSPECTIVE, T.PRICE_BOOK_NAME, T.PL_AGR_BSA_NAME, T.PUB_TEMPLATE_NAME , T.LANGUAGE, T.SOURCE_LANG, B.CUST_ACCOUNT_ID 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.DLV_XML_FLAG
, B.PUB_TEMPLATE_CODE
, B.PUB_LANGUAGE
, B.PUB_TERRITORY
, B.PUB_OUTPUT_DOCUMENT_TYPE
, 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
, QP_PRICE_BOOK_UTIL.GET_ATTRIBUTE_NAME(B.CUSTOMER_CONTEXT
, B.CUSTOMER_ATTRIBUTE
, 'QUALIFIER') CUSTOMER_ATTRIBUTE_NAME
, QP_PRICE_BOOK_UTIL.GET_CUSTOMER_VALUE(B.CUSTOMER_ATTRIBUTE
, B.CUSTOMER_ATTR_VALUE) CUSTOMER_NAME
, QP_PRICE_BOOK_UTIL.GET_CURRENCY_NAME(B.CURRENCY_CODE) CURRENCY
, QP_PRICE_BOOK_UTIL.VALUE_TO_MEANING(B.LIMIT_PRODUCTS_BY
, 'PB_PRODUCT_CRITERIA_LIMIT_BY') LIMIT_PRODUCTS_BY_NAME
, QP_PRICE_BOOK_UTIL.GET_ATTRIBUTE_NAME(B.PRODUCT_CONTEXT
, B.PRODUCT_ATTRIBUTE
, 'PRODUCT') PRODUCT_ATTRIBUTE_NAME
, QP_PRICE_BOOK_UTIL.GET_PRODUCT_VALUE(B.PRODUCT_ATTRIBUTE
, B.PRODUCT_ATTR_VALUE
, B.ORG_ID) PRODUCT_NAME
, QP_PRICE_BOOK_UTIL.VALUE_TO_MEANING(B.GENERATION_TIME_CODE
, 'QP_GEN_TIME_CODE') GENERATION_TIME
, QP_PRICE_BOOK_UTIL.GET_OPERATING_UNIT(B.ORG_ID) OPERATING_UNIT
, QP_PRICE_BOOK_UTIL.VALUE_TO_MEANING(B.PRICE_BOOK_TYPE_CODE
, 'PRICE_BOOK_TYPE_CODE') PRICE_BOOK_TYPE
, QP_PRICE_BOOK_UTIL.VALUE_TO_MEANING(B.PRICE_BASED_ON
, 'PB_CALCULATION_BASED_ON') PRICE_BASED_ON_NAME
, QP_PRICE_BOOK_UTIL.VALUE_TO_MEANING(B.PRICING_PERSPECTIVE_CODE
, 'QP_PRICING_PERSPECTIVE') PRICING_PERSPECTIVE
, T.PRICE_BOOK_NAME
, T.PL_AGR_BSA_NAME
, T.PUB_TEMPLATE_NAME
, T.LANGUAGE
, T.SOURCE_LANG
, B.CUST_ACCOUNT_ID
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')