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: EAM.EAM_WORK_ORDER_BILLS#

Source

View Text - Preformatted


select ORGANIZATION_ID ORGANIZATION_ID, CUSTOMER_ID CUSTOMER_ID, BILL_TO_ADDRESS_ID BILL_TO_ADDRESS_ID, WIP_ENTITY_ID WIP_ENTITY_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, RESOURCE_ID RESOURCE_ID, BILLED_INVENTORY_ITEM_ID BILLED_INVENTORY_ITEM_ID, BILLED_UOM_CODE BILLED_UOM_CODE, BILLED_QUANTITY BILLED_QUANTITY, BILLING_BASIS BILLING_BASIS, PRICE_LIST_HEADER_ID PRICE_LIST_HEADER_ID, COST_TYPE_ID COST_TYPE_ID, COST_OR_LISTPRICE COST_OR_LISTPRICE, COSTPLUS_PERCENTAGE COSTPLUS_PERCENTAGE, BILLED_AMOUNT BILLED_AMOUNT, INVOICE_TRX_NUMBER INVOICE_TRX_NUMBER, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER, CURRENCY_CODE CURRENCY_CODE, CONVERSION_RATE CONVERSION_RATE, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE, CONVERSION_RATE_DATE CONVERSION_RATE_DATE, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, WORK_REQUEST_ID WORK_REQUEST_ID, PA_EVENT_ID PA_EVENT_ID, BILLING_METHOD BILLING_METHOD, OVERRIDE_BILL_AMOUNT OVERRIDE_BILL_AMOUNT, DYNAMIC_BILLING_ACTIVITY DYNAMIC_BILLING_ACTIVITY, MASS_ADDITION_ID MASS_ADDITION_ID, CAPITALIZATION_DATE CAPITALIZATION_DATE, COMMENTS COMMENTS, FIXED_ASSET_NUMBER FIXED_ASSET_NUMBER, OFFSET_ACCOUNT_CCID OFFSET_ACCOUNT_CCID from "EAM"."EAM_WORK_ORDER_BILLS"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, CUSTOMER_ID CUSTOMER_ID
, BILL_TO_ADDRESS_ID BILL_TO_ADDRESS_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, RESOURCE_ID RESOURCE_ID
, BILLED_INVENTORY_ITEM_ID BILLED_INVENTORY_ITEM_ID
, BILLED_UOM_CODE BILLED_UOM_CODE
, BILLED_QUANTITY BILLED_QUANTITY
, BILLING_BASIS BILLING_BASIS
, PRICE_LIST_HEADER_ID PRICE_LIST_HEADER_ID
, COST_TYPE_ID COST_TYPE_ID
, COST_OR_LISTPRICE COST_OR_LISTPRICE
, COSTPLUS_PERCENTAGE COSTPLUS_PERCENTAGE
, BILLED_AMOUNT BILLED_AMOUNT
, INVOICE_TRX_NUMBER INVOICE_TRX_NUMBER
, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER
, CURRENCY_CODE CURRENCY_CODE
, CONVERSION_RATE CONVERSION_RATE
, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE
, CONVERSION_RATE_DATE CONVERSION_RATE_DATE
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, WORK_REQUEST_ID WORK_REQUEST_ID
, PA_EVENT_ID PA_EVENT_ID
, BILLING_METHOD BILLING_METHOD
, OVERRIDE_BILL_AMOUNT OVERRIDE_BILL_AMOUNT
, DYNAMIC_BILLING_ACTIVITY DYNAMIC_BILLING_ACTIVITY
, MASS_ADDITION_ID MASS_ADDITION_ID
, CAPITALIZATION_DATE CAPITALIZATION_DATE
, COMMENTS COMMENTS
, FIXED_ASSET_NUMBER FIXED_ASSET_NUMBER
, OFFSET_ACCOUNT_CCID OFFSET_ACCOUNT_CCID
FROM "EAM"."EAM_WORK_ORDER_BILLS"