JL Transfer Journal Entries to GL for Latin American AR and AP

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: Latin America Localizations
Source: Transfer Journal Entries to GL for Latin American AR and AP
Short Name: JLARAPTR
DB package: XLA_CREATE_ACCT_RPT_PVT

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Ledger
 
LOV Oracle
Process Category
 
LOV Oracle
End Date
 
Date
Post in General Ledger
 
LOV Oracle
General Ledger Batch Name
 
Char