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: GMF.GMF_INVOICE_DISTRIBUTIONS#

Source

View Text - Preformatted


select DISTRIBUTION_ID DISTRIBUTION_ID, CALENDAR_CODE CALENDAR_CODE, PERIOD_CODE PERIOD_CODE, COST_MTHD_CODE COST_MTHD_CODE, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, ITEM_ID ITEM_ID, WHSE_CODE WHSE_CODE, COST_CMPNTCLS_ID COST_CMPNTCLS_ID, COST_ANALYSIS_CODE#1 COST_ANALYSIS_CODE, QUANTITY_INVOICED QUANTITY_INVOICED, QUANTITY_COSTED QUANTITY_COSTED, TOTAL_QUANTITY TOTAL_QUANTITY, UNIT_BASE_PRICE UNIT_BASE_PRICE, QUANTITY_UOM QUANTITY_UOM, BASE_IPV_AMOUNT BASE_IPV_AMOUNT, IPV_AMOUNT IPV_AMOUNT, BASE_IPV_ADJ_AMOUNT BASE_IPV_ADJ_AMOUNT, IPV_ADJ_AMOUNT IPV_ADJ_AMOUNT, ACCOUNTED_DATE ACCOUNTED_DATE, OUT_OF_PERIOD_IND OUT_OF_PERIOD_IND, GL_POSTED_IND GL_POSTED_IND, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, 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, BASE_ERV_ADJ_AMOUNT BASE_ERV_ADJ_AMOUNT, BASE_ERV_AMOUNT BASE_ERV_AMOUNT, ERV_ADJ_AMOUNT ERV_ADJ_AMOUNT, ERV_AMOUNT ERV_AMOUNT, INVOICE_VARIANCE_TYPE INVOICE_VARIANCE_TYPE, PERIOD_ID PERIOD_ID, COST_TYPE_ID COST_TYPE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, ACCOUNTED_FLAG ACCOUNTED_FLAG, FINAL_POSTING_DATE FINAL_POSTING_DATE from "GMF"."GMF_INVOICE_DISTRIBUTIONS"

View Text - HTML Formatted

SELECT DISTRIBUTION_ID DISTRIBUTION_ID
, CALENDAR_CODE CALENDAR_CODE
, PERIOD_CODE PERIOD_CODE
, COST_MTHD_CODE COST_MTHD_CODE
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, ITEM_ID ITEM_ID
, WHSE_CODE WHSE_CODE
, COST_CMPNTCLS_ID COST_CMPNTCLS_ID
, COST_ANALYSIS_CODE#1 COST_ANALYSIS_CODE
, QUANTITY_INVOICED QUANTITY_INVOICED
, QUANTITY_COSTED QUANTITY_COSTED
, TOTAL_QUANTITY TOTAL_QUANTITY
, UNIT_BASE_PRICE UNIT_BASE_PRICE
, QUANTITY_UOM QUANTITY_UOM
, BASE_IPV_AMOUNT BASE_IPV_AMOUNT
, IPV_AMOUNT IPV_AMOUNT
, BASE_IPV_ADJ_AMOUNT BASE_IPV_ADJ_AMOUNT
, IPV_ADJ_AMOUNT IPV_ADJ_AMOUNT
, ACCOUNTED_DATE ACCOUNTED_DATE
, OUT_OF_PERIOD_IND OUT_OF_PERIOD_IND
, GL_POSTED_IND GL_POSTED_IND
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, 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
, BASE_ERV_ADJ_AMOUNT BASE_ERV_ADJ_AMOUNT
, BASE_ERV_AMOUNT BASE_ERV_AMOUNT
, ERV_ADJ_AMOUNT ERV_ADJ_AMOUNT
, ERV_AMOUNT ERV_AMOUNT
, INVOICE_VARIANCE_TYPE INVOICE_VARIANCE_TYPE
, PERIOD_ID PERIOD_ID
, COST_TYPE_ID COST_TYPE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, ACCOUNTED_FLAG ACCOUNTED_FLAG
, FINAL_POSTING_DATE FINAL_POSTING_DATE
FROM "GMF"."GMF_INVOICE_DISTRIBUTIONS"