eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: PA.PA_COMMITMENT_TXNS_EFC#

Source

View Text - Preformatted


select CMT_LINE_ID CMT_LINE_ID, TOT_CMT_RAW_COST TOT_CMT_RAW_COST, TOT_CMT_BURDENED_COST TOT_CMT_BURDENED_COST, AMOUNT_ORDERED AMOUNT_ORDERED, ORIGINAL_AMOUNT_ORDERED ORIGINAL_AMOUNT_ORDERED, AMOUNT_CANCELLED AMOUNT_CANCELLED, AMOUNT_DELIVERED AMOUNT_DELIVERED, AMOUNT_INVOICED AMOUNT_INVOICED, AMOUNT_OUTSTANDING_DELIVERY AMOUNT_OUTSTANDING_DELIVERY, AMOUNT_OUTSTANDING_INVOICE AMOUNT_OUTSTANDING_INVOICE, AMOUNT_OVERBILLED AMOUNT_OVERBILLED, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CREATION_DATE CREATION_DATE, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE, RECEIPT_CURRENCY_AMOUNT RECEIPT_CURRENCY_AMOUNT, RECEIPT_EXCHANGE_RATE RECEIPT_EXCHANGE_RATE, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE, DENOM_RAW_COST DENOM_RAW_COST, DENOM_BURDENED_COST DENOM_BURDENED_COST, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE, ACCT_RAW_COST ACCT_RAW_COST, ACCT_BURDENED_COST ACCT_BURDENED_COST, ACCT_RATE_DATE ACCT_RATE_DATE, ACCT_RATE_TYPE ACCT_RATE_TYPE, ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, PROJECT_RATE_DATE PROJECT_RATE_DATE, PROJECT_RATE_TYPE PROJECT_RATE_TYPE, PROJECT_EXCHANGE_RATE PROJECT_EXCHANGE_RATE from "PA"."PA_COMMITMENT_TXNS_EFC"

View Text - HTML Formatted

SELECT CMT_LINE_ID CMT_LINE_ID
, TOT_CMT_RAW_COST TOT_CMT_RAW_COST
, TOT_CMT_BURDENED_COST TOT_CMT_BURDENED_COST
, AMOUNT_ORDERED AMOUNT_ORDERED
, ORIGINAL_AMOUNT_ORDERED ORIGINAL_AMOUNT_ORDERED
, AMOUNT_CANCELLED AMOUNT_CANCELLED
, AMOUNT_DELIVERED AMOUNT_DELIVERED
, AMOUNT_INVOICED AMOUNT_INVOICED
, AMOUNT_OUTSTANDING_DELIVERY AMOUNT_OUTSTANDING_DELIVERY
, AMOUNT_OUTSTANDING_INVOICE AMOUNT_OUTSTANDING_INVOICE
, AMOUNT_OVERBILLED AMOUNT_OVERBILLED
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CREATION_DATE CREATION_DATE
, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE
, RECEIPT_CURRENCY_AMOUNT RECEIPT_CURRENCY_AMOUNT
, RECEIPT_EXCHANGE_RATE RECEIPT_EXCHANGE_RATE
, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE
, DENOM_RAW_COST DENOM_RAW_COST
, DENOM_BURDENED_COST DENOM_BURDENED_COST
, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE
, ACCT_RAW_COST ACCT_RAW_COST
, ACCT_BURDENED_COST ACCT_BURDENED_COST
, ACCT_RATE_DATE ACCT_RATE_DATE
, ACCT_RATE_TYPE ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, PROJECT_RATE_DATE PROJECT_RATE_DATE
, PROJECT_RATE_TYPE PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE PROJECT_EXCHANGE_RATE
FROM "PA"."PA_COMMITMENT_TXNS_EFC"