JA Transfer Journal Entries to GL for Asia/Pacific FA

Description
Categories: BI Publisher
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
Post in GL
 
Transfer To GL
 
Report Level
 
Errors Only
 
Accounting Mode Name
 
Create Accounting
 
Process Category Name
 
Ledger Name
 
Application Name
 
Source Application Name
 
Mixed Currency Precision
 
Number
XLA_SRS_NO_VALIDATION
 
Transfer to General Ledger
 
LOV Oracle
Report
 
LOV Oracle
XLA_SRS_ACCOUNTING_MODE_DUMMY
 
XLA_SRS_NO_VALIDATION
 
Create Accounting
 
LOV Oracle
XLA_SRS_NO_VALIDATION
 
Application
 
LOV Oracle
Source Application
 
LOV Oracle
General Ledger Batch Name
 
Post in General Ledger
 
LOV Oracle
End Date
 
Date
Process Category
 
LOV Oracle
Ledger
 
LOV Oracle
Book Type Code
 
LOV Oracle