QP_PB_CHARGE_COMPS

Details

Schema: FUSION
Object owner: QP
Object type: VIEW

Columns

Name
PB_CHARGE_COMPONENT_ID PRICE_BOOK_CHARGE_ID PRICE_BOOK_LINE_ID PRICE_BOOK_ID CHARGE_CURRENCY_CODE CHARGE_CURRENCY_EXT_AMOUNT HEADER_CURRENCY_CODE HEADER_CURRENCY_EXT_AMOUNT PRICE_ELEMENT_CODE PRICE_ELEMENT_USAGE_CODE SEQUENCE_NUMBER CHARGE_CURRENCY_UNIT_PRICE HEADER_CURRENCY_UNIT_PRICE ROLLUP_FLAG PRICING_SOURCE_ID PRICING_SOURCE_TYPE_CODE EXPLANATION_MESSAGE_NAME MESSAGE_TOKEN_INFO CHARGE_CURR_DURATION_EXT_AMT HEADER_CURR_DURATION_EXT_AMT CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER EXPLANATION_MESSAGE

Name

PB_CHARGE_COMPONENT_ID

PRICE_BOOK_CHARGE_ID

PRICE_BOOK_LINE_ID

PRICE_BOOK_ID

CHARGE_CURRENCY_CODE

CHARGE_CURRENCY_EXT_AMOUNT

HEADER_CURRENCY_CODE

HEADER_CURRENCY_EXT_AMOUNT

PRICE_ELEMENT_CODE

PRICE_ELEMENT_USAGE_CODE

SEQUENCE_NUMBER

CHARGE_CURRENCY_UNIT_PRICE

HEADER_CURRENCY_UNIT_PRICE

ROLLUP_FLAG

PRICING_SOURCE_ID

PRICING_SOURCE_TYPE_CODE

EXPLANATION_MESSAGE_NAME

MESSAGE_TOKEN_INFO

CHARGE_CURR_DURATION_EXT_AMT

HEADER_CURR_DURATION_EXT_AMT

CREATION_DATE

CREATED_BY

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

EXPLANATION_MESSAGE

Query

SQL_Statement
SELECT QP_PB_CHARGE_COMPS_B.PB_CHARGE_COMPONENT_ID PB_CHARGE_COMPONENT_ID, QP_PB_CHARGE_COMPS_B.PRICE_BOOK_CHARGE_ID PRICE_BOOK_CHARGE_ID, QP_PB_CHARGE_COMPS_B.PRICE_BOOK_LINE_ID PRICE_BOOK_LINE_ID, QP_PB_CHARGE_COMPS_B.PRICE_BOOK_ID PRICE_BOOK_ID, QP_PB_CHARGE_COMPS_B.CHARGE_CURRENCY_CODE CHARGE_CURRENCY_CODE, QP_PB_CHARGE_COMPS_B.CHARGE_CURRENCY_EXT_AMOUNT CHARGE_CURRENCY_EXT_AMOUNT, QP_PB_CHARGE_COMPS_B.HEADER_CURRENCY_CODE HEADER_CURRENCY_CODE, QP_PB_CHARGE_COMPS_B.HEADER_CURRENCY_EXT_AMOUNT HEADER_CURRENCY_EXT_AMOUNT, QP_PB_CHARGE_COMPS_B.PRICE_ELEMENT_CODE PRICE_ELEMENT_CODE, QP_PB_CHARGE_COMPS_B.PRICE_ELEMENT_USAGE_CODE PRICE_ELEMENT_USAGE_CODE, QP_PB_CHARGE_COMPS_B.SEQUENCE_NUMBER SEQUENCE_NUMBER, QP_PB_CHARGE_COMPS_B.CHARGE_CURRENCY_UNIT_PRICE CHARGE_CURRENCY_UNIT_PRICE, QP_PB_CHARGE_COMPS_B.HEADER_CURRENCY_UNIT_PRICE HEADER_CURRENCY_UNIT_PRICE, QP_PB_CHARGE_COMPS_B.ROLLUP_FLAG ROLLUP_FLAG, QP_PB_CHARGE_COMPS_B.PRICING_SOURCE_ID PRICING_SOURCE_ID, QP_PB_CHARGE_COMPS_B.PRICING_SOURCE_TYPE_CODE PRICING_SOURCE_TYPE_CODE, QP_PB_CHARGE_COMPS_B.EXPLANATION_MESSAGE_NAME EXPLANATION_MESSAGE_NAME, QP_PB_CHARGE_COMPS_B.MESSAGE_TOKEN_INFO MESSAGE_TOKEN_INFO, QP_PB_CHARGE_COMPS_B.CHARGE_CURR_DURATION_EXT_AMT CHARGE_CURR_DURATION_EXT_AMT, QP_PB_CHARGE_COMPS_B.HEADER_CURR_DURATION_EXT_AMT HEADER_CURR_DURATION_EXT_AMT, QP_PB_CHARGE_COMPS_B.CREATION_DATE CREATION_DATE, QP_PB_CHARGE_COMPS_B.CREATED_BY CREATED_BY, QP_PB_CHARGE_COMPS_B.LAST_UPDATED_BY LAST_UPDATED_BY, QP_PB_CHARGE_COMPS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, QP_PB_CHARGE_COMPS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, QP_PB_CHARGE_COMPS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, QP_PB_CHARGE_COMPS_TL.EXPLANATION_MESSAGE EXPLANATION_MESSAGE FROM QP_PB_CHARGE_COMPS_B, QP_PB_CHARGE_COMPS_TL WHERE QP_PB_CHARGE_COMPS_B.PB_CHARGE_COMPONENT_ID = QP_PB_CHARGE_COMPS_TL.PB_CHARGE_COMPONENT_ID AND QP_PB_CHARGE_COMPS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

QP_PB_CHARGE_COMPS_B.PB_CHARGE_COMPONENT_ID PB_CHARGE_COMPONENT_ID,

QP_PB_CHARGE_COMPS_B.PRICE_BOOK_CHARGE_ID PRICE_BOOK_CHARGE_ID,

QP_PB_CHARGE_COMPS_B.PRICE_BOOK_LINE_ID PRICE_BOOK_LINE_ID,

QP_PB_CHARGE_COMPS_B.PRICE_BOOK_ID PRICE_BOOK_ID,

QP_PB_CHARGE_COMPS_B.CHARGE_CURRENCY_CODE CHARGE_CURRENCY_CODE,

QP_PB_CHARGE_COMPS_B.CHARGE_CURRENCY_EXT_AMOUNT CHARGE_CURRENCY_EXT_AMOUNT,

QP_PB_CHARGE_COMPS_B.HEADER_CURRENCY_CODE HEADER_CURRENCY_CODE,

QP_PB_CHARGE_COMPS_B.HEADER_CURRENCY_EXT_AMOUNT HEADER_CURRENCY_EXT_AMOUNT,

QP_PB_CHARGE_COMPS_B.PRICE_ELEMENT_CODE PRICE_ELEMENT_CODE,

QP_PB_CHARGE_COMPS_B.PRICE_ELEMENT_USAGE_CODE PRICE_ELEMENT_USAGE_CODE,

QP_PB_CHARGE_COMPS_B.SEQUENCE_NUMBER SEQUENCE_NUMBER,

QP_PB_CHARGE_COMPS_B.CHARGE_CURRENCY_UNIT_PRICE CHARGE_CURRENCY_UNIT_PRICE,

QP_PB_CHARGE_COMPS_B.HEADER_CURRENCY_UNIT_PRICE HEADER_CURRENCY_UNIT_PRICE,

QP_PB_CHARGE_COMPS_B.ROLLUP_FLAG ROLLUP_FLAG,

QP_PB_CHARGE_COMPS_B.PRICING_SOURCE_ID PRICING_SOURCE_ID,

QP_PB_CHARGE_COMPS_B.PRICING_SOURCE_TYPE_CODE PRICING_SOURCE_TYPE_CODE,

QP_PB_CHARGE_COMPS_B.EXPLANATION_MESSAGE_NAME EXPLANATION_MESSAGE_NAME,

QP_PB_CHARGE_COMPS_B.MESSAGE_TOKEN_INFO MESSAGE_TOKEN_INFO,

QP_PB_CHARGE_COMPS_B.CHARGE_CURR_DURATION_EXT_AMT CHARGE_CURR_DURATION_EXT_AMT,

QP_PB_CHARGE_COMPS_B.HEADER_CURR_DURATION_EXT_AMT HEADER_CURR_DURATION_EXT_AMT,

QP_PB_CHARGE_COMPS_B.CREATION_DATE CREATION_DATE,

QP_PB_CHARGE_COMPS_B.CREATED_BY CREATED_BY,

QP_PB_CHARGE_COMPS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

QP_PB_CHARGE_COMPS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

QP_PB_CHARGE_COMPS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

QP_PB_CHARGE_COMPS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

QP_PB_CHARGE_COMPS_TL.EXPLANATION_MESSAGE EXPLANATION_MESSAGE

FROM

QP_PB_CHARGE_COMPS_B,

QP_PB_CHARGE_COMPS_TL

WHERE

QP_PB_CHARGE_COMPS_B.PB_CHARGE_COMPONENT_ID = QP_PB_CHARGE_COMPS_TL.PB_CHARGE_COMPONENT_ID AND QP_PB_CHARGE_COMPS_TL.LANGUAGE = USERENV('LANG')