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
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