VIEW: APPS.AR_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 , AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount(JGTH.GTA_TRX_HEADER_ID) , AR_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(+)

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
, AR_GTA_TRX_UTIL.GET_GTAINVOICE_AMOUNT(JGTH.GTA_TRX_HEADER_ID)
, AR_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(+)