VIEW: APPS.AR_GTA_GT_HEADERS_V

Source

View Text - Preformatted

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 WHERE JGTH.SOURCE='GT' AND JGTH.RA_TRX_ID=RCT.CUSTOMER_TRX_ID(+)

View Text - HTML Formatted

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
WHERE JGTH.SOURCE='GT'
AND JGTH.RA_TRX_ID=RCT.CUSTOMER_TRX_ID(+)