VIEW: GMF.GMF_LC_ADJ_TRANSACTIONS#

Source

View Text - Preformatted

select ADJ_TRANSACTION_ID ADJ_TRANSACTION_ID, RCV_TRANSACTION_ID RCV_TRANSACTION_ID, EVENT_TYPE EVENT_TYPE, EVENT_SOURCE EVENT_SOURCE, EVENT_SOURCE_ID EVENT_SOURCE_ID, LEDGER_ID LEDGER_ID, ORG_ID ORG_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, PARENT_SHIP_LINE_ID PARENT_SHIP_LINE_ID, SHIP_HEADER_ID SHIP_HEADER_ID, SHIP_LINE_GROUP_ID SHIP_LINE_GROUP_ID, SHIP_LINE_ID SHIP_LINE_ID, ADJUSTMENT_NUM ADJUSTMENT_NUM, PARENT_TABLE_NAME PARENT_TABLE_NAME, PARENT_TABLE_ID PARENT_TABLE_ID, PRIOR_LANDED_COST PRIOR_LANDED_COST, NEW_LANDED_COST NEW_LANDED_COST, CHARGE_LINE_TYPE_ID CHARGE_LINE_TYPE_ID, CHARGE_LINE_TYPE_CODE CHARGE_LINE_TYPE_CODE, COST_ACQUISITION_FLAG COST_ACQUISITION_FLAG, COMPONENT_TYPE COMPONENT_TYPE, COMPONENT_NAME COMPONENT_NAME, COST_CMPNTCLS_ID COST_CMPNTCLS_ID, COST_ANALYSIS_CODE#1 COST_ANALYSIS_CODE, LC_ADJUSTMENT_FLAG LC_ADJUSTMENT_FLAG, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, TRANSACTION_UOM_CODE TRANSACTION_UOM_CODE, PRIMARY_QUANTITY PRIMARY_QUANTITY, PRIMARY_UOM_CODE PRIMARY_UOM_CODE, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, LC_SHIP_NUM LC_SHIP_NUM, LC_SHIP_LINE_NUM LC_SHIP_LINE_NUM, LC_VAR_ACCOUNT_ID LC_VAR_ACCOUNT_ID, LC_ABSORPTION_ACCOUNT_ID LC_ABSORPTION_ACCOUNT_ID, ACCOUNTED_FLAG ACCOUNTED_FLAG, FINAL_POSTING_DATE FINAL_POSTING_DATE, 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_UDPATE_DATE PROGRAM_UDPATE_DATE from "GMF"."GMF_LC_ADJ_TRANSACTIONS"

View Text - HTML Formatted

SELECT ADJ_TRANSACTION_ID ADJ_TRANSACTION_ID
, RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, EVENT_TYPE EVENT_TYPE
, EVENT_SOURCE EVENT_SOURCE
, EVENT_SOURCE_ID EVENT_SOURCE_ID
, LEDGER_ID LEDGER_ID
, ORG_ID ORG_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, PARENT_SHIP_LINE_ID PARENT_SHIP_LINE_ID
, SHIP_HEADER_ID SHIP_HEADER_ID
, SHIP_LINE_GROUP_ID SHIP_LINE_GROUP_ID
, SHIP_LINE_ID SHIP_LINE_ID
, ADJUSTMENT_NUM ADJUSTMENT_NUM
, PARENT_TABLE_NAME PARENT_TABLE_NAME
, PARENT_TABLE_ID PARENT_TABLE_ID
, PRIOR_LANDED_COST PRIOR_LANDED_COST
, NEW_LANDED_COST NEW_LANDED_COST
, CHARGE_LINE_TYPE_ID CHARGE_LINE_TYPE_ID
, CHARGE_LINE_TYPE_CODE CHARGE_LINE_TYPE_CODE
, COST_ACQUISITION_FLAG COST_ACQUISITION_FLAG
, COMPONENT_TYPE COMPONENT_TYPE
, COMPONENT_NAME COMPONENT_NAME
, COST_CMPNTCLS_ID COST_CMPNTCLS_ID
, COST_ANALYSIS_CODE#1 COST_ANALYSIS_CODE
, LC_ADJUSTMENT_FLAG LC_ADJUSTMENT_FLAG
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, TRANSACTION_UOM_CODE TRANSACTION_UOM_CODE
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, LC_SHIP_NUM LC_SHIP_NUM
, LC_SHIP_LINE_NUM LC_SHIP_LINE_NUM
, LC_VAR_ACCOUNT_ID LC_VAR_ACCOUNT_ID
, LC_ABSORPTION_ACCOUNT_ID LC_ABSORPTION_ACCOUNT_ID
, ACCOUNTED_FLAG ACCOUNTED_FLAG
, FINAL_POSTING_DATE FINAL_POSTING_DATE
, 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_UDPATE_DATE PROGRAM_UDPATE_DATE
FROM "GMF"."GMF_LC_ADJ_TRANSACTIONS"