从总账日记账追溯到应收收款代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】从总账日记账追溯到应收收款

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

--从总账日记账追溯到应收收款
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
      ,ADA.LINE_ID
  FROM GL_JE_LINES_V        GJL
      ,AR_CASH_RECEIPTS_ALL ACRA
      ,AR_DISTRIBUTIONS_ALL ADA
 WHERE (GJL.JE_HEADER_ID = 3332299)
   AND GJL.DESCRIPTION LIKE '%20120113001%' --收款编号
   AND GJL.SUBLEDGER_DOC_SEQUENCE_ID = ACRA.DOC_SEQUENCE_ID
   AND GJL.SUBLEDGER_DOC_SEQUENCE_VALUE = ACRA.DOC_SEQUENCE_VALUE
   AND ADA.LINE_ID = GJL.REFERENCE_3 --收款分配ID
 ORDER BY JE_LINE_NUM;

试试其它关键字

　从总账日记账追溯到应收收款　

同语言下

可能有用的

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