VIEW: APPS.JMF_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 JMF_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 JMF_GTA_TRX_HEADERS_ALL JGTH
, RA_CUSTOMER_TRX_ALL RCT
WHERE JGTH.SOURCE='GT'
AND JGTH.RA_TRX_ID=RCT.CUSTOMER_TRX_ID(+)