FOS_TRANSFER_PRICE_V

Details

• Schema: FUSION

• Object owner: FOS

• Object type: VIEW

Columns

Name

PRICING_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE PRICING_OPTION_NAME PRICING_OPTION_DESC TP_PRICING_BASIS_FLAG TP_TXN_COST_BASIS_FLAG TP_DOC_PRICE_BASIS_FLAG TP_OPTIONS_CRITERIA TP_USE_SOPRICE_FLAG TP_DOC_MARKUP_TYPE TP_DOC_MARKUP_VALUE TP_COST_MARKUP_TYPE TP_COST_MARKUP_VALUE TP_ITEM_COST_BASIS_FLAG TP_ITEM_COST_MARKUP_VALUE PRICING_DETAIL_ID DOCUMENT_ID DOCUMENT_TYPE SOURCE_SYSTEM_ID PRICE_TYPE BASIS AGREEMENT_FTR_ID AS_ON_EFFECTIVE_DATE UNIT_PRICE UNIT_OF_MEASURE CURRENCY_CODE CONVERSION_TYPE CHARGE_ID PRICE_ELEMENT_CODE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REFERENCE_INFORMATION EVENT_DATA_ID EVENT_DEFINITION_ID

Query

SQL_Statement

SELECT pricingoption.pricing_id, pricingoption.effective_start_date, pricingoption.effective_end_date, pricingoption.pricing_option_name, pricingoption.pricing_option_desc, pricingoption.tp_pricing_basis_flag, pricingoption.tp_txn_cost_basis_flag, pricingoption.tp_doc_price_basis_flag, pricingoption.tp_options_criteria, pricingoption.tp_use_soprice_flag, pricingoption.tp_doc_markup_type, pricingoption.tp_doc_markup_value, pricingoption.tp_cost_markup_type, pricingoption.tp_cost_markup_value, pricingoption.tp_item_cost_basis_flag, pricingoption.tp_item_cost_markup_value, pricingdetails.pricing_detail_id, pricingdetails.document_id, pricingdetails.document_type, pricingdetails.source_system_id, pricingdetails.price_type, pricingdetails.basis, pricingdetails.agreement_ftr_id, pricingdetails.as_on_effective_date, pricingdetails.unit_price, pricingdetails.unit_of_measure, pricingdetails.currency_code, pricingdetails.conversion_type, pricingdetails.charge_id, pricingdetails.price_element_code, pricingdetails.object_version_number, pricingdetails.created_by, pricingdetails.creation_date, pricingdetails.last_updated_by, pricingdetails.last_update_date, pricingdetails.last_update_login, pricingdetails.reference_information, pricingdetails.event_data_id, pricingdetails.event_definition_id FROM FOS_PRICING_OPTION_F pricingoption, FOS_PRICING_DETAILS pricingdetails WHERE pricingoption.pricing_id = pricingdetails.pricing_id AND (pricingdetails.as_on_effective_date BETWEEN pricingoption.effective_start_date AND pricingoption.effective_end_date)