VIEW: APPS.OZF_FUNDS_UTILIZED_ALL_VL

Source

View Text - Preformatted

SELECT B.ROWID ,B.utilization_id ,B.last_update_date ,B.last_updated_by ,B.last_update_login ,B.creation_date ,B.created_by ,B.created_from ,B.request_id ,B.program_application_id ,B.program_id ,B.program_update_date ,B.utilization_type ,B.fund_id ,B.plan_type ,B.plan_id ,B.component_type ,B.component_id ,B.object_type ,B.object_id ,B.order_id ,B.invoice_id ,B.amount ,B.AMOUNT_REMAINING ,B.acctd_amount ,B.ACCTD_AMOUNT_REMAINING ,B.currency_code ,B.exchange_rate_type ,B.exchange_rate_date ,B.exchange_rate ,B.adjustment_type ,B.adjustment_date ,T.adjustment_desc ,B.object_version_number ,B.attribute_category ,B.attribute1 ,B.attribute2 ,B.attribute3 ,B.attribute4 ,B.attribute5 ,B.attribute6 ,B.attribute7 ,B.attribute8 ,B.attribute9 ,B.attribute10 ,B.attribute11 ,B.attribute12 ,B.attribute13 ,B.attribute14 ,B.attribute15 ,B.org_id ,B.ADJUSTMENT_TYPE_ID ,B.CAMP_SCHEDULE_ID ,B.PRODUCT_ID ,B.CUST_ACCOUNT_ID ,B.AMS_ACTIVITY_BUDGET_ID ,B.PRODUCT_LEVEL_TYPE ,B.GL_DATE ,B.PRICE_ADJUSTMENT_ID ,B.PLAN_CURR_AMOUNT ,B.PLAN_CURR_AMOUNT_REMAINING ,B.scan_unit ,B.scan_unit_remaining ,B.activity_product_id ,B.volume_offer_tiers_id ,B.gl_posted_flag ,B.billto_cust_account_id ,B.ship_to_site_use_id ,B.bill_to_site_use_id ,B.reference_type ,B. reference_id ,B.ORDER_LINE_ID ,B.orig_utilization_id ,B.univ_curr_amount ,B.univ_curr_amount_remaining ,B.fund_request_amount ,B.fund_request_amount_remaining ,B.fund_request_currency_code ,B.plan_currency_code FROM OZF_FUNDS_UTILIZED_ALL_B B, OZF_FUNDS_UTILIZED_ALL_TL T WHERE B.utilization_id = T.utilization_id AND T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID
, B.UTILIZATION_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATION_DATE
, B.CREATED_BY
, B.CREATED_FROM
, B.REQUEST_ID
, B.PROGRAM_APPLICATION_ID
, B.PROGRAM_ID
, B.PROGRAM_UPDATE_DATE
, B.UTILIZATION_TYPE
, B.FUND_ID
, B.PLAN_TYPE
, B.PLAN_ID
, B.COMPONENT_TYPE
, B.COMPONENT_ID
, B.OBJECT_TYPE
, B.OBJECT_ID
, B.ORDER_ID
, B.INVOICE_ID
, B.AMOUNT
, B.AMOUNT_REMAINING
, B.ACCTD_AMOUNT
, B.ACCTD_AMOUNT_REMAINING
, B.CURRENCY_CODE
, B.EXCHANGE_RATE_TYPE
, B.EXCHANGE_RATE_DATE
, B.EXCHANGE_RATE
, B.ADJUSTMENT_TYPE
, B.ADJUSTMENT_DATE
, T.ADJUSTMENT_DESC
, B.OBJECT_VERSION_NUMBER
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.ORG_ID
, B.ADJUSTMENT_TYPE_ID
, B.CAMP_SCHEDULE_ID
, B.PRODUCT_ID
, B.CUST_ACCOUNT_ID
, B.AMS_ACTIVITY_BUDGET_ID
, B.PRODUCT_LEVEL_TYPE
, B.GL_DATE
, B.PRICE_ADJUSTMENT_ID
, B.PLAN_CURR_AMOUNT
, B.PLAN_CURR_AMOUNT_REMAINING
, B.SCAN_UNIT
, B.SCAN_UNIT_REMAINING
, B.ACTIVITY_PRODUCT_ID
, B.VOLUME_OFFER_TIERS_ID
, B.GL_POSTED_FLAG
, B.BILLTO_CUST_ACCOUNT_ID
, B.SHIP_TO_SITE_USE_ID
, B.BILL_TO_SITE_USE_ID
, B.REFERENCE_TYPE
, B. REFERENCE_ID
, B.ORDER_LINE_ID
, B.ORIG_UTILIZATION_ID
, B.UNIV_CURR_AMOUNT
, B.UNIV_CURR_AMOUNT_REMAINING
, B.FUND_REQUEST_AMOUNT
, B.FUND_REQUEST_AMOUNT_REMAINING
, B.FUND_REQUEST_CURRENCY_CODE
, B.PLAN_CURRENCY_CODE
FROM OZF_FUNDS_UTILIZED_ALL_B B
, OZF_FUNDS_UTILIZED_ALL_TL T
WHERE B.UTILIZATION_ID = T.UTILIZATION_ID
AND T.LANGUAGE = USERENV('LANG')