应收模块发票及收款数据与总账的关联即如何由总账追溯代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】应收模块发票及收款数据与总账的关联即如何由总账追溯

作者:专注Oracle EBS / 发布于2012/11/29/ 988

--应收模块发票及收款数据与总账的关联即如何由总账追溯到应收

--从总账日记账追溯到应收发票
SELECT GJL.JE_LINE_NUM
      ,GJL.ENTERED_DR
      ,GJL.ENTERED_CR
      ,GJL.ACCOUNTED_DR
      ,GJL.ACCOUNTED_CR
      ,GJL.STAT_AMOUNT
      ,GJL.DESCRIPTION
      ,GJL.TRANSLATION_RATE
      ,GJL.TRANSLATION_AMOUNT
      ,GJL.USSGL_TRANSACTION_CODE
      ,GJL.SET_OF_BOOKS_ID
      ,GJL.CODE_COMBINATION_ID
      ,GJL.ROW_ID
      ,GJL.STATUS
      ,GJL.PERIOD_NAME
      ,GJL.IGNORE_RATE_FLAG
      ,GJL.EFFECTIVE_DATE
      ,GJL.REFERENCE_1
      ,GJL.REFERENCE_2
      ,GJL.REFERENCE_3
      ,GJL.REFERENCE_4
      ,GJL.REFERENCE_5
      ,GJL.REFERENCE_6
      ,GJL.REFERENCE_7
      ,GJL.REFERENCE_8
      ,GJL.REFERENCE_9
      ,GJL.REFERENCE_10
      ,GJL.CONTEXT
      ,GJL.ATTRIBUTE1
      ,GJL.ATTRIBUTE2
      ,GJL.ATTRIBUTE3
      ,GJL.ATTRIBUTE4
      ,GJL.ATTRIBUTE5
      ,GJL.ATTRIBUTE6
      ,GJL.ATTRIBUTE7
      ,GJL.ATTRIBUTE8
      ,GJL.ATTRIBUTE9
      ,GJL.ATTRIBUTE10
      ,GJL.CONTEXT2
      ,GJL.ATTRIBUTE11
      ,GJL.ATTRIBUTE12
      ,GJL.ATTRIBUTE13
      ,GJL.ATTRIBUTE14
      ,GJL.ATTRIBUTE15
      ,GJL.ATTRIBUTE16
      ,GJL.ATTRIBUTE17
      ,GJL.ATTRIBUTE18
      ,GJL.ATTRIBUTE19
      ,GJL.ATTRIBUTE20
      ,GJL.CONTEXT3
      ,GJL.TAX_CODE
      ,GJL.INVOICE_DATE
      ,GJL.INVOICE_IDENTIFIER
      ,GJL.INVOICE_AMOUNT
      ,GJL.NO1
      ,GJL.TAXABLE_LINE_FLAG
      ,GJL.TAX_TYPE_CODE
      ,GJL.TAX_CODE_ID
      ,GJL.TAX_ROUNDING_RULE_CODE
      ,GJL.AMOUNT_INCLUDES_TAX_FLAG
      ,GJL.TAX_DOCUMENT_IDENTIFIER
      ,GJL.TAX_DOCUMENT_DATE
      ,GJL.TAX_CUSTOMER_NAME
      ,GJL.TAX_CUSTOMER_REFERENCE
      ,GJL.TAX_REGISTRATION_NUMBER
      ,GJL.TAX_LINE_FLAG
      ,GJL.TAX_GROUP_ID
      ,GJL.CONTEXT4
      ,GJL.JGZZ_RECON_CONTEXT
      ,GJL.JGZZ_RECON_STATUS
      ,GJL.JGZZ_RECON_DATE
      ,GJL.JGZZ_RECON_ID
      ,GJL.JGZZ_RECON_REF
      ,GJL.JE_HEADER_ID
      ,GJL.GLOBAL_ATTRIBUTE1
      ,GJL.GLOBAL_ATTRIBUTE2
      ,GJL.GLOBAL_ATTRIBUTE3
      ,GJL.GLOBAL_ATTRIBUTE4
      ,GJL.GLOBAL_ATTRIBUTE5
      ,GJL.GLOBAL_ATTRIBUTE6
      ,GJL.GLOBAL_ATTRIBUTE7
      ,GJL.GLOBAL_ATTRIBUTE8
      ,GJL.GLOBAL_ATTRIBUTE9
      ,GJL.GLOBAL_ATTRIBUTE10
      ,GJL.GLOBAL_ATTRIBUTE_CATEGORY
      ,GJL.SUBLEDGER_DOC_SEQUENCE_ID
      ,GJL.SUBLEDGER_DOC_SEQUENCE_VALUE
      ,GJL.CREATION_DATE
      ,GJL.CREATED_BY
      ,GJL.LAST_UPDATE_DATE
      ,GJL.LAST_UPDATED_BY
      ,GJL.LAST_UPDATE_LOGIN
      ,GJL.WAD_ROW_ID
      ,GJL.TRANSACTION_TYPE
      ,GJL.TRANSACTION_DETAIL_TYPE
      ,GJL.EXCEPTION_FLAG
      ,GJL.AMOUNTS_FILLED_FLAG
      ,GJL.TO_CURRENCY_CODE
      ,GJL.TRANSLATED_DR
      ,GJL.TRANSLATED_CR
  FROM GL_JE_LINES_V                GJL
      ,RA_CUSTOMER_TRX_ALL          RCTA
      ,RA_CUST_TRX_LINE_GL_DIST_ALL RCLGDA
 WHERE (JE_HEADER_ID = 3332300)
   AND DESCRIPTION LIKE '%80210595%' --事务处理编号
   AND RCLGDA.CUST_TRX_LINE_GL_DIST_ID = GJL.REFERENCE_3
   AND GJL.REFERENCE_4 = RCTA.TRX_NUMBER
   AND GJL.REFERENCE_2 = RCTA.CUSTOMER_TRX_ID
   AND GJL.SUBLEDGER_DOC_SEQUENCE_ID = RCTA.DOC_SEQUENCE_ID
   AND GJL.SUBLEDGER_DOC_SEQUENCE_VALUE = RCTA.DOC_SEQUENCE_VALUE

试试其它关键字

　从总账日记账追溯到应收发票　

同语言下

可能有用的

专注Oracle EBS贡献的其它代码(66)