DBA Data[Home] [Help]

APPS.JA_CN_AR_RBD_EXPORT_PKG dependencies on AR_ADJUSTMENTS_ALL

Line 782: FROM AR_ADJUSTMENTS_ALL Adj,

778: Ael.Accounted_Dr Accounted_Dr,
779: Ael.Accounted_Cr Accounted_Cr,
780: Ael.Entered_Dr Entered_Dr,
781: Ael.Entered_Cr Entered_Cr
782: FROM AR_ADJUSTMENTS_ALL Adj,
783: Xla_Transaction_Entities Ent,
784: Xla_Ae_Headers Aeh,
785: Xla_Ae_Lines Ael,
786: Gl_Import_References Gir,

Line 1768: FROM AR_ADJUSTMENTS_ALL Adj,

1764: AND Aeh.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1765: AND App.Applied_Customer_Trx_Id IS NOT NULL
1766: UNION
1767: SELECT DISTINCT Adj.Customer_Trx_Id Customer_Trx_Id
1768: FROM AR_ADJUSTMENTS_ALL Adj,
1769: Xla_Transaction_Entities Ent,
1770: Xla_Ae_Headers Aeh
1771: WHERE Ent.Application_Id = 222
1772: AND Adj.Adjustment_Id = Ent.Source_Id_Int_1

Line 1864: FROM AR_ADJUSTMENTS_ALL Adj,

1860: (gp.end_date BETWEEN ld_start_date AND ld_end_date))
1861: UNION
1862: --from adjustment
1863: SELECT DISTINCT Gp.Period_Name,Gp.Start_Date,Gp.End_Date
1864: FROM AR_ADJUSTMENTS_ALL Adj,
1865: Gl_Ledgers Gl,
1866: Gl_Periods Gp
1867: WHERE Adj.Customer_Trx_Id = ln_customer_trx_id --variable: ln_customer_trx_id
1868: AND Gl.ledger_id = pn_ledger_id --parameter: pn_ledger_id

Line 2214: FROM AR_ADJUSTMENTS_ALL Adj,

2210: Jeh.Je_Category Journal_Category_Number,
2211: Adj.Adjustment_Id Adjustment_Id,
2212: Adj.Comments Description,
2213: TO_CHAR(Adj.Gl_Date,'YYYYMMDD') Applied_Date
2214: FROM AR_ADJUSTMENTS_ALL Adj,
2215: Xla_Transaction_Entities Ent,
2216: Xla_Ae_Headers Aeh,
2217: Xla_Ae_Lines Ael,
2218: Gl_Import_References Gir,