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: AR_GTA_GT_HEADERS_V

Product:	AR - Receivables
Description:	Header level information for gta invoice
Implementation/DBA Data:	APPS.AR_GTA_GT_HEADERS_V

View Text

SELECT JGTH.ROWID
, JGTH.ORG_ID
, JGTH.GTA_TRX_HEADER_ID
, JGTH.GTA_TRX_NUMBER
, JGTH.GT_INVOICE_NUMBER
, JGTH.GT_INVOICE_DATE
, JGTH.BILL_TO_CUSTOMER_NAME
, JGTH.CUSTOMER_ADDRESS_PHONE
, JGTH.BANK_ACCOUNT_NAME_NUMBER
, JGTH.STATUS
, JGTH.DESCRIPTION
, JGTH.GT_INVOICE_NET_AMOUNT
, JGTH.GT_INVOICE_TAX_AMOUNT
, JGTH.CREATION_DATE
, JGTH.CREATED_BY
, JGTH.LAST_UPDATE_DATE
, JGTH.LAST_UPDATED_BY
, JGTH.LAST_UPDATE_LOGIN
, JGTH.REQUEST_ID
, JGTH.PROGRAM_APPLICATION_ID
, JGTH.PROGRAM_ID
, JGTH.PROGRAM_UPDATE_DATE
, JGTH.GT_INVOICE_NET_AMOUNT+JGTH.GT_INVOICE_TAX_AMOUNT
, JGTH.RA_TRX_ID
, RCT.TRX_NUMBER
, JGTH.FP_TAX_REGISTRATION_NUMBER
, JGTH.TP_TAX_REGISTRATION_NUMBER
, JGTH.INVOICE_TYPE
FROM AR_GTA_TRX_HEADERS_ALL JGTH
, RA_CUSTOMER_TRX_ALL RCT
FROM AR_GTA_TRX_HEADERS_ALL JGTH
, RA_CUSTOMER_TRX_ALL RCT
WHERE JGTH.SOURCE='GT'
AND JGTH.RA_TRX_ID=RCT.CUSTOMER_TRX_ID(+)

Columns

Name
ROW_ID
ORG_ID
GTA_TRX_HEADER_ID
GTA_INVOICE_NUMBER
VAT_INVOICE_NUMBER
VAT_INVOICE_DATE
CUSTOMER_NAME
CUSTOMER_ADDRESS_PHONE
BANK_ACCOUNT_NAME_NUMBER
STATUS
DESCRIPTION
VAT_NET_AMOUNT
VAT_TAX_AMOUNT
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
TOTAL_VAT_INVOICE_AMOUNT
RA_TRX_ID
RA_TRX_NUM
FP_TAX_REGISTRATION_NUMBER
TP_TAX_REGISTRATION_NUMBER
INVOICE_TYPE