View: AR_GTA_TRX_HEADERS_V

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

View Text

SELECT JGTH.ROWID
, JGTH.RA_GL_DATE
, JGTH.RA_GL_PERIOD
, JGTH.SET_OF_BOOKS_ID
, JGTH.BILL_TO_CUSTOMER_ID
, JGTH.BILL_TO_CUSTOMER_NUMBER
, JGTH.BILL_TO_CUSTOMER_NAME
, JGTH.SOURCE
, JGTH.ORG_ID
, JGTH.RULE_HEADER_ID
, JGTH.GTA_TRX_HEADER_ID
, JGTH.GTA_TRX_NUMBER
, JGTH.GROUP_NUMBER
, JGTH.VERSION
, JGTH.LATEST_VERSION_FLAG
, JGTH.TRANSACTION_DATE
, JGTH.RA_TRX_ID
, JGTH.DESCRIPTION
, JGTH.CUSTOMER_ADDRESS
, JGTH.CUSTOMER_PHONE
, JGTH.CUSTOMER_ADDRESS_PHONE
, JGTH.BANK_ACCOUNT_NAME
, JGTH.BANK_ACCOUNT_NUMBER
, JGTH.BANK_ACCOUNT_NAME_NUMBER
, JGTH.RA_CURRENCY_CODE
, JGTH.CONVERSION_TYPE
, JGTH.CONVERSION_DATE
, JGTH.CONVERSION_RATE
, JGTH.GTA_BATCH_NUMBER
, JGTH.GT_INVOICE_NUMBER
, JGTH.GT_INVOICE_DATE
, JGTH.GT_INVOICE_NET_AMOUNT
, JGTH.GT_INVOICE_TAX_AMOUNT
, JGTH.STATUS
, JGTH.SALES_LIST_FLAG
, JGTH.CANCEL_FLAG
, JGTH.GT_INVOICE_TYPE
, JGTH.GT_INVOICE_CLASS
, JGTH.GT_TAX_MONTH
, JGTH.ISSUER_NAME
, JGTH.REVIEWER_NAME
, JGTH.PAYEE_NAME
, JGTH.TAX_CODE
, JGTH.TAX_RATE
, JGTH.GENERATOR_ID
, JGTH.EXPORT_REQUEST_ID
, 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.ATTRIBUTE_CATEGORY
, JGTH.ATTRIBUTE1
, JGTH.ATTRIBUTE2
, JGTH.ATTRIBUTE3
, JGTH.ATTRIBUTE4
, JGTH.ATTRIBUTE5
, JGTH.ATTRIBUTE6
, JGTH.ATTRIBUTE7
, JGTH.ATTRIBUTE8
, JGTH.ATTRIBUTE9
, JGTH.ATTRIBUTE10
, JGTH.ATTRIBUTE11
, JGTH.ATTRIBUTE12
, JGTH.ATTRIBUTE13
, JGTH.ATTRIBUTE14
, JGTH.ATTRIBUTE15
, JGTH.GT_INVOICE_NET_AMOUNT+JGTH.GT_INVOICE_TAX_AMOUNT
, NULL
, --JMF_GTA_TRX_UTIL.GET_GTAINVOICE_AMOUNT(JGTH.GTA_TRX_HEADER_ID)
, NULL
, --JMF_GTA_TRX_UTIL.GET_GTAINVOICE_ORIGINAL_AMOUNT(JGTH.GTA_TRX_HEADER_ID)
, OTL.NAME
, JGRH.RULE_NAME
, RCTT.TYPE
, RCTT.NAME
, RB.NAME
, JGTH.RA_TRX_NUMBER
, RBS.NAME
, RCT.DOC_SEQUENCE_VALUE
, RCT.COMPLETE_FLAG
, RCT.PRIMARY_SALESREP_ID
, JGTH.LEGAL_ENTITY_ID
, JGTH.FP_TAX_REGISTRATION_NUMBER
, JGTH.TP_TAX_REGISTRATION_NUMBER
, JGTH.INVOICE_TYPE
, JGTH.CONSOLIDATION_ID
, JGTH.CONSOLIDATION_FLAG
, JGTH.CONSOLIDATION_TRX_NUM
, JGTH.CONSOLIDATION_REQUEST_ID
FROM AR_GTA_TRX_HEADERS_ALL JGTH
, RA_CUSTOMER_TRX_ALL RCT
, HR_ALL_ORGANIZATION_UNITS OU
, HR_ALL_ORGANIZATION_UNITS_TL OTL
, AR_GTA_RULE_HEADERS_ALL JGRH
, RA_CUST_TRX_TYPES_ALL RCTT
, RA_BATCHES_ALL RB
, RA_BATCH_SOURCES_ALL RBS
WHERE JGTH.SOURCE='AR'
AND JGTH.RA_TRX_ID=RCT.CUSTOMER_TRX_ID(+)
AND JGTH.ORG_ID=OU.ORGANIZATION_ID
AND OU.ORGANIZATION_ID = OTL.ORGANIZATION_ID
AND OTL.LANGUAGE = USERENV('LANG')
AND JGTH.ORG_ID=JGRH.ORG_ID(+)
AND JGTH.RULE_HEADER_ID=JGRH.RULE_HEADER_ID(+)
AND RCT.ORG_ID=RCTT.ORG_ID(+)
AND RCT.CUST_TRX_TYPE_ID=RCTT.CUST_TRX_TYPE_ID(+)
AND RCT.BATCH_ID=RB.BATCH_ID(+)
AND RCT.ORG_ID=RBS.ORG_ID(+)
AND RCT.BATCH_SOURCE_ID=RBS.BATCH_SOURCE_ID(+)

Columns