JA Transfer Journal Entries to GL for Asia/Pacific 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 for Asia/Pacific AR and AP
Application: Asia/Pacific Localizations
Source: Transfer Journal Entries to GL for Asia/Pacific AR and AP
Short Name: JAARAPTR
DB package: XLA_CREATE_ACCT_RPT_PVT
Run JA Transfer Journal Entries to GL for Asia/Pacific AR and AP 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
Ledger
 
LOV Oracle
Process Category
 
LOV Oracle
End Date
 
Date
Post in General Ledger
 
LOV Oracle
General Ledger Batch Name
 
Char
Blitz Report™