VIEW: GMF.GMF_PERIOD_BALANCES#

Source

View Text - Preformatted

select PERIOD_BALANCE_ID PERIOD_BALANCE_ID, ACCT_PERIOD_ID ACCT_PERIOD_ID, ORGANIZATION_ID ORGANIZATION_ID, COST_GROUP_ID COST_GROUP_ID, SUBINVENTORY_CODE SUBINVENTORY_CODE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, LOT_NUMBER LOT_NUMBER, LOCATOR_ID LOCATOR_ID, PRIMARY_QUANTITY PRIMARY_QUANTITY, SECONDARY_QUANTITY SECONDARY_QUANTITY, INTRANSIT_PRIMARY_QUANTITY INTRANSIT_PRIMARY_QUANTITY, INTRANSIT_SECONDARY_QUANTITY INTRANSIT_SECONDARY_QUANTITY, ACCOUNTED_VALUE ACCOUNTED_VALUE, INTRANSIT_ACCOUNTED_VALUE INTRANSIT_ACCOUNTED_VALUE, COSTED_FLAG COSTED_FLAG, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_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, PERIOD_CLOSE_STATUS PERIOD_CLOSE_STATUS from "GMF"."GMF_PERIOD_BALANCES"

View Text - HTML Formatted

SELECT PERIOD_BALANCE_ID PERIOD_BALANCE_ID
, ACCT_PERIOD_ID ACCT_PERIOD_ID
, ORGANIZATION_ID ORGANIZATION_ID
, COST_GROUP_ID COST_GROUP_ID
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, LOT_NUMBER LOT_NUMBER
, LOCATOR_ID LOCATOR_ID
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, SECONDARY_QUANTITY SECONDARY_QUANTITY
, INTRANSIT_PRIMARY_QUANTITY INTRANSIT_PRIMARY_QUANTITY
, INTRANSIT_SECONDARY_QUANTITY INTRANSIT_SECONDARY_QUANTITY
, ACCOUNTED_VALUE ACCOUNTED_VALUE
, INTRANSIT_ACCOUNTED_VALUE INTRANSIT_ACCOUNTED_VALUE
, COSTED_FLAG COSTED_FLAG
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_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
, PERIOD_CLOSE_STATUS PERIOD_CLOSE_STATUS
FROM "GMF"."GMF_PERIOD_BALANCES"