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#

Source

View Text - Preformatted


select CMT_LINE_ID CMT_LINE_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, TRANSACTION_SOURCE TRANSACTION_SOURCE, LINE_TYPE LINE_TYPE, CMT_NUMBER CMT_NUMBER, CMT_DISTRIBUTION_ID CMT_DISTRIBUTION_ID, DESCRIPTION DESCRIPTION, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, PA_PERIOD PA_PERIOD, GL_PERIOD GL_PERIOD, CMT_LINE_NUMBER CMT_LINE_NUMBER, CMT_CREATION_DATE CMT_CREATION_DATE, CMT_APPROVED_DATE CMT_APPROVED_DATE, CMT_REQUESTOR_NAME CMT_REQUESTOR_NAME, CMT_BUYER_NAME CMT_BUYER_NAME, CMT_APPROVED_FLAG CMT_APPROVED_FLAG, CMT_PROMISED_DATE CMT_PROMISED_DATE, CMT_NEED_BY_DATE CMT_NEED_BY_DATE, CMT_HEADER_ID CMT_HEADER_ID, ORGANIZATION_ID ORGANIZATION_ID, VENDOR_ID VENDOR_ID, VENDOR_NAME VENDOR_NAME, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY, REVENUE_CATEGORY REVENUE_CATEGORY, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION, UNIT_OF_MEASURE UNIT_OF_MEASURE, UNIT_PRICE UNIT_PRICE, CMT_IND_COMPILED_SET_ID CMT_IND_COMPILED_SET_ID, TOT_CMT_RAW_COST TOT_CMT_RAW_COST, TOT_CMT_BURDENED_COST TOT_CMT_BURDENED_COST, TOT_CMT_QUANTITY TOT_CMT_QUANTITY, QUANTITY_ORDERED QUANTITY_ORDERED, AMOUNT_ORDERED AMOUNT_ORDERED, ORIGINAL_QUANTITY_ORDERED ORIGINAL_QUANTITY_ORDERED, ORIGINAL_AMOUNT_ORDERED ORIGINAL_AMOUNT_ORDERED, QUANTITY_CANCELLED QUANTITY_CANCELLED, AMOUNT_CANCELLED AMOUNT_CANCELLED, QUANTITY_DELIVERED QUANTITY_DELIVERED, AMOUNT_DELIVERED AMOUNT_DELIVERED, QUANTITY_INVOICED QUANTITY_INVOICED, AMOUNT_INVOICED AMOUNT_INVOICED, QUANTITY_OUTSTANDING_DELIVERY QUANTITY_OUTSTANDING_DELIVERY, AMOUNT_OUTSTANDING_DELIVERY AMOUNT_OUTSTANDING_DELIVERY, QUANTITY_OUTSTANDING_INVOICE QUANTITY_OUTSTANDING_INVOICE, AMOUNT_OUTSTANDING_INVOICE AMOUNT_OUTSTANDING_INVOICE, QUANTITY_OVERBILLED QUANTITY_OVERBILLED, AMOUNT_OVERBILLED AMOUNT_OVERBILLED, ORIGINAL_TXN_REFERENCE1 ORIGINAL_TXN_REFERENCE1, ORIGINAL_TXN_REFERENCE2 ORIGINAL_TXN_REFERENCE2, ORIGINAL_TXN_REFERENCE3 ORIGINAL_TXN_REFERENCE3, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, BURDEN_SUM_SOURCE_RUN_ID BURDEN_SUM_SOURCE_RUN_ID, BURDEN_SUM_DEST_RUN_ID BURDEN_SUM_DEST_RUN_ID, BURDEN_SUM_REJECTION_CODE BURDEN_SUM_REJECTION_CODE, 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, CMT_REJECTION_CODE CMT_REJECTION_CODE, GENERATION_ERROR_FLAG GENERATION_ERROR_FLAG, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, BOM_LABOR_RESOURCE_ID BOM_LABOR_RESOURCE_ID, BOM_EQUIPMENT_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID, PROJ_RAW_COST PROJ_RAW_COST, PROJ_BURDENED_COST PROJ_BURDENED_COST, PROJ_CURRENCY_CODE PROJ_CURRENCY_CODE, PROJ_RATE_DATE PROJ_RATE_DATE, PROJ_RATE_TYPE PROJ_RATE_TYPE, PROJ_EXCHANGE_RATE PROJ_EXCHANGE_RATE, UOM_CODE UOM_CODE, RESOURCE_CLASS RESOURCE_CLASS, SRC_SYSTEM_LINKAGE_FUNCTION SRC_SYSTEM_LINKAGE_FUNCTION, CBS_ELEMENT_ID CBS_ELEMENT_ID from "PA"."PA_COMMITMENT_TXNS"

View Text - HTML Formatted

SELECT CMT_LINE_ID CMT_LINE_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, TRANSACTION_SOURCE TRANSACTION_SOURCE
, LINE_TYPE LINE_TYPE
, CMT_NUMBER CMT_NUMBER
, CMT_DISTRIBUTION_ID CMT_DISTRIBUTION_ID
, DESCRIPTION DESCRIPTION
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, PA_PERIOD PA_PERIOD
, GL_PERIOD GL_PERIOD
, CMT_LINE_NUMBER CMT_LINE_NUMBER
, CMT_CREATION_DATE CMT_CREATION_DATE
, CMT_APPROVED_DATE CMT_APPROVED_DATE
, CMT_REQUESTOR_NAME CMT_REQUESTOR_NAME
, CMT_BUYER_NAME CMT_BUYER_NAME
, CMT_APPROVED_FLAG CMT_APPROVED_FLAG
, CMT_PROMISED_DATE CMT_PROMISED_DATE
, CMT_NEED_BY_DATE CMT_NEED_BY_DATE
, CMT_HEADER_ID CMT_HEADER_ID
, ORGANIZATION_ID ORGANIZATION_ID
, VENDOR_ID VENDOR_ID
, VENDOR_NAME VENDOR_NAME
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY
, REVENUE_CATEGORY REVENUE_CATEGORY
, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, UNIT_PRICE UNIT_PRICE
, CMT_IND_COMPILED_SET_ID CMT_IND_COMPILED_SET_ID
, TOT_CMT_RAW_COST TOT_CMT_RAW_COST
, TOT_CMT_BURDENED_COST TOT_CMT_BURDENED_COST
, TOT_CMT_QUANTITY TOT_CMT_QUANTITY
, QUANTITY_ORDERED QUANTITY_ORDERED
, AMOUNT_ORDERED AMOUNT_ORDERED
, ORIGINAL_QUANTITY_ORDERED ORIGINAL_QUANTITY_ORDERED
, ORIGINAL_AMOUNT_ORDERED ORIGINAL_AMOUNT_ORDERED
, QUANTITY_CANCELLED QUANTITY_CANCELLED
, AMOUNT_CANCELLED AMOUNT_CANCELLED
, QUANTITY_DELIVERED QUANTITY_DELIVERED
, AMOUNT_DELIVERED AMOUNT_DELIVERED
, QUANTITY_INVOICED QUANTITY_INVOICED
, AMOUNT_INVOICED AMOUNT_INVOICED
, QUANTITY_OUTSTANDING_DELIVERY QUANTITY_OUTSTANDING_DELIVERY
, AMOUNT_OUTSTANDING_DELIVERY AMOUNT_OUTSTANDING_DELIVERY
, QUANTITY_OUTSTANDING_INVOICE QUANTITY_OUTSTANDING_INVOICE
, AMOUNT_OUTSTANDING_INVOICE AMOUNT_OUTSTANDING_INVOICE
, QUANTITY_OVERBILLED QUANTITY_OVERBILLED
, AMOUNT_OVERBILLED AMOUNT_OVERBILLED
, ORIGINAL_TXN_REFERENCE1 ORIGINAL_TXN_REFERENCE1
, ORIGINAL_TXN_REFERENCE2 ORIGINAL_TXN_REFERENCE2
, ORIGINAL_TXN_REFERENCE3 ORIGINAL_TXN_REFERENCE3
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, BURDEN_SUM_SOURCE_RUN_ID BURDEN_SUM_SOURCE_RUN_ID
, BURDEN_SUM_DEST_RUN_ID BURDEN_SUM_DEST_RUN_ID
, BURDEN_SUM_REJECTION_CODE BURDEN_SUM_REJECTION_CODE
, 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
, CMT_REJECTION_CODE CMT_REJECTION_CODE
, GENERATION_ERROR_FLAG GENERATION_ERROR_FLAG
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, BOM_LABOR_RESOURCE_ID BOM_LABOR_RESOURCE_ID
, BOM_EQUIPMENT_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID
, PROJ_RAW_COST PROJ_RAW_COST
, PROJ_BURDENED_COST PROJ_BURDENED_COST
, PROJ_CURRENCY_CODE PROJ_CURRENCY_CODE
, PROJ_RATE_DATE PROJ_RATE_DATE
, PROJ_RATE_TYPE PROJ_RATE_TYPE
, PROJ_EXCHANGE_RATE PROJ_EXCHANGE_RATE
, UOM_CODE UOM_CODE
, RESOURCE_CLASS RESOURCE_CLASS
, SRC_SYSTEM_LINKAGE_FUNCTION SRC_SYSTEM_LINKAGE_FUNCTION
, CBS_ELEMENT_ID CBS_ELEMENT_ID
FROM "PA"."PA_COMMITMENT_TXNS"