JA Transfer Journal Entries to GL for Asia/Pacific FA
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Use this program to transfer to GL subledger journal entries generated by previous executions of the create accounting program
Application: Asia/Pacific Localizations
Source: Transfer Journal Entries to GL for Asia/Pacific FA
Short Name: JAFATRJE
DB package: XLA_CREATE_ACCT_RPT_PVT
Description: Use this program to transfer to GL subledger journal entries generated by previous executions of the create accounting program
Application: Asia/Pacific Localizations
Source: Transfer Journal Entries to GL for Asia/Pacific FA
Short Name: JAFATRJE
DB package: XLA_CREATE_ACCT_RPT_PVT
Run
JA Transfer Journal Entries to GL for Asia/Pacific FA and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT AEH.LEDGER_ID LEDGER_ID , GLL.NAME LEDGER_NAME -- the following two columns are intentionally kept null as there is a -- possibility that the following query will not perform and then -- we will have to rely on this information coming from transfer package -- In that case we will not be able to provide this information. -- If this query performs okay, the two null columns can be replaced by -- actual values. , NULL BALANCE_TYPE_CODE , NULL BALANCE_TYPE , COUNT(DECODE(AEH.GL_TRANSFER_STATUS_CODE,'Y',1,NULL)) JE_TRANSFERRED_COUNT , COUNT(DECODE(AEH.GL_TRANSFER_STATUS_CODE,'Y',NULL,1)) JE_NOT_TRANSFERRED_COUNT FROM XLA_AE_HEADERS AEH , GL_LEDGERS GLL --, XLA_LOOKUPS XLK WHERE AEH.APPLICATION_ID = :APPLICATION_ID AND AEH.REQUEST_ID = &P_REQ_ID AND GLL.LEDGER_ID = AEH.LEDGER_ID AND AEH.GROUP_ID IN (&P_GROUP_ID_STR) --AND XLK.LOOKUP_TYPE = 'XLA_BALANCE_TYPE' --AND XLK.LOOKUP_CODE = AEH.BALANCE_TYPE_CODE GROUP BY AEH.LEDGER_ID ,GLL.NAME --,AEH.BALANCE_TYPE_CODE --,XLK.MEANING |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Book Type Code |
|
LOV Oracle | |
Ledger |
|
LOV Oracle | |
Process Category |
|
LOV Oracle | |
End Date |
|
Date | |
Post in General Ledger |
|
LOV Oracle | |
General Ledger Batch Name |
|
Char |