VIEW: JA.JAI_CMN_RG_PLA_CMP_DTLS#

Source

View Text - Preformatted

select ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, FIN_YEAR FIN_YEAR, REGISTER_ID REGISTER_ID, SLNO SLNO, BASIC_OPENING_BALANCE BASIC_OPENING_BALANCE, ADDITIONAL_OPENING_BALANCE ADDITIONAL_OPENING_BALANCE, OTHER_OPENING_BALANCE OTHER_OPENING_BALANCE, CR_BASIC_ED CR_BASIC_ED, CR_ADDITIONAL_ED CR_ADDITIONAL_ED, CR_OTHER_ED CR_OTHER_ED, DR_BASIC_ED DR_BASIC_ED, DR_ADDITIONAL_ED DR_ADDITIONAL_ED, DR_OTHER_ED DR_OTHER_ED, BASIC_CLOSING_BALANCE BASIC_CLOSING_BALANCE, ADDITIONAL_CLOSING_BALANCE ADDITIONAL_CLOSING_BALANCE, OTHER_CLOSING_BALANCE OTHER_CLOSING_BALANCE, TRANSACTION_DATE TRANSACTION_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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JA"."JAI_CMN_RG_PLA_CMP_DTLS"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, FIN_YEAR FIN_YEAR
, REGISTER_ID REGISTER_ID
, SLNO SLNO
, BASIC_OPENING_BALANCE BASIC_OPENING_BALANCE
, ADDITIONAL_OPENING_BALANCE ADDITIONAL_OPENING_BALANCE
, OTHER_OPENING_BALANCE OTHER_OPENING_BALANCE
, CR_BASIC_ED CR_BASIC_ED
, CR_ADDITIONAL_ED CR_ADDITIONAL_ED
, CR_OTHER_ED CR_OTHER_ED
, DR_BASIC_ED DR_BASIC_ED
, DR_ADDITIONAL_ED DR_ADDITIONAL_ED
, DR_OTHER_ED DR_OTHER_ED
, BASIC_CLOSING_BALANCE BASIC_CLOSING_BALANCE
, ADDITIONAL_CLOSING_BALANCE ADDITIONAL_CLOSING_BALANCE
, OTHER_CLOSING_BALANCE OTHER_CLOSING_BALANCE
, TRANSACTION_DATE TRANSACTION_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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JA"."JAI_CMN_RG_PLA_CMP_DTLS"