DBA Data[Home] [Help]

VIEW: JA.JAI_AR_TRX_SUP_INV_T#

Source

View Text - Preformatted

select CUSTOMER_TRX_ID CUSTOMER_TRX_ID, MAPPING_ID MAPPING_ID, TRX_DATE TRX_DATE, EFFECTIVE_DATE EFFECTIVE_DATE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CUSTOMER_ID CUSTOMER_ID, ORG_ID ORG_ID, CUSTOMER_SITE CUSTOMER_SITE, COMB_NO COMB_NO, MAPPING_TYPE MAPPING_TYPE, INTERFACE_HEADER_CONTEXT INTERFACE_HEADER_CONTEXT, INTERFACE_HEADER_ATTRIBUTE1 INTERFACE_HEADER_ATTRIBUTE1, INTERFACE_HEADER_ATTRIBUTE6 INTERFACE_HEADER_ATTRIBUTE6, INTERFACE_HEADER_ATTRIBUTE7 INTERFACE_HEADER_ATTRIBUTE7, EXISTING_TYPE_ID EXISTING_TYPE_ID, NEW_TYPE_ID NEW_TYPE_ID, CONVERSION_RATE CONVERSION_RATE, 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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JA"."JAI_AR_TRX_SUP_INV_T"
View Text - HTML Formatted

SELECT CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, MAPPING_ID MAPPING_ID
, TRX_DATE TRX_DATE
, EFFECTIVE_DATE EFFECTIVE_DATE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CUSTOMER_ID CUSTOMER_ID
, ORG_ID ORG_ID
, CUSTOMER_SITE CUSTOMER_SITE
, COMB_NO COMB_NO
, MAPPING_TYPE MAPPING_TYPE
, INTERFACE_HEADER_CONTEXT INTERFACE_HEADER_CONTEXT
, INTERFACE_HEADER_ATTRIBUTE1 INTERFACE_HEADER_ATTRIBUTE1
, INTERFACE_HEADER_ATTRIBUTE6 INTERFACE_HEADER_ATTRIBUTE6
, INTERFACE_HEADER_ATTRIBUTE7 INTERFACE_HEADER_ATTRIBUTE7
, EXISTING_TYPE_ID EXISTING_TYPE_ID
, NEW_TYPE_ID NEW_TYPE_ID
, CONVERSION_RATE CONVERSION_RATE
, 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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JA"."JAI_AR_TRX_SUP_INV_T"