VIEW: APPS.JMF_GTA_TRX_HEADERS_V

Source

View Text - Preformatted

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 ,JMF_GTA_TRX_UTIL.Get_Gtainvoice_Amount(JGTH.GTA_TRX_HEADER_ID) ,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 FROM JMF_GTA_TRX_HEADERS_ALL JGTH ,RA_CUSTOMER_TRX_ALL RCT ,HR_ALL_ORGANIZATION_UNITS OU ,HR_ALL_ORGANIZATION_UNITS_TL OTL ,JMF_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(+)

View Text - HTML Formatted

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
, JMF_GTA_TRX_UTIL.GET_GTAINVOICE_AMOUNT(JGTH.GTA_TRX_HEADER_ID)
, 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
FROM JMF_GTA_TRX_HEADERS_ALL JGTH
, RA_CUSTOMER_TRX_ALL RCT
, HR_ALL_ORGANIZATION_UNITS OU
, HR_ALL_ORGANIZATION_UNITS_TL OTL
, JMF_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(+)