PA Transfer Journal Entries to GL
Description
Categories: BI Publisher
Application: Projects
Source: PRC: Transfer Journal Entries to GL
Short Name: PAXGLTRN
DB package: XLA_CREATE_ACCT_RPT_PVT
Source: PRC: Transfer Journal Entries to GL
Short Name: PAXGLTRN
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 | |
---|---|---|---|
Process Category |
|
LOV Oracle | |
End Date |
|
Date | |
Post in General Ledger |
|
LOV Oracle | |
General Ledger Batch Name |
|
||
Source Application |
|
LOV Oracle | |
Application |
|
LOV Oracle | |
XLA_SRS_NO_VALIDATION |
|
||
PA_XLA_SRS_SUBLEDGER_LEDGERS |
|
LOV Oracle | |
Create Accounting |
|
LOV Oracle | |
XLA_SRS_NO_VALIDATION |
|
||
Dummy Parameter |
|
||
Transfer to General Ledger |
|
||
XLA_SRS_NO_VALIDATION |
|
||
Mixed Currency Precision |
|
Number | |
Source Application Name |
|
||
Application Name |
|
||
Ledger Name |
|
||
Process Category Name |
|
||
Create Acct |
|
||
Accounting Mode Name |
|
||
Errors Only |
|
||
Report Level |
|
||
Transfer to GL |
|
||
Post in GL |
|
||
Operating Unit |
|