[Home] [Help]
34: ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE,
35: GLDate DATE, -- the gl date of the application
36: TrxDate DATE, -- the apply date of the application
37: AppType ar_receivable_applications.application_type%TYPE,
38: CatMeaning ar_lookups.meaning%TYPE,
39: PostingControlId ar_receivable_applications.posting_control_id%TYPE
40: );
41: --
42: -- holds ApplicationAmount values
1230: cr.org_id OrgId
1231: FROM ar_receivable_applications ra,
1232: ar_cash_receipts cr,
1233: hz_cust_accounts cust,
1234: ar_lookups l_cat
1235: WHERE ra.gl_date BETWEEN p_Report.GlDateFrom
1236: AND p_Report.GLDateTo
1237: AND nvl(ra.postable,'Y') = 'Y'
1238: AND nvl(ra.confirmed_flag,'Y') = 'Y'
1482: ra_customer_trx ct,
1483: ar_cash_receipts cr,
1484: ar_cash_receipt_history crh,
1485: ra_customer_trx ctcm,
1486: ar_lookups l,
1487: ar_lookups l_cat,
1488: hz_cust_accounts cust
1489: WHERE ra.gl_date BETWEEN p_Report.GlDateFrom
1490: AND p_Report.GLDateTo
1483: ar_cash_receipts cr,
1484: ar_cash_receipt_history crh,
1485: ra_customer_trx ctcm,
1486: ar_lookups l,
1487: ar_lookups l_cat,
1488: hz_cust_accounts cust
1489: WHERE ra.gl_date BETWEEN p_Report.GlDateFrom
1490: AND p_Report.GLDateTo
1491: AND nvl(ra.postable,'Y') = 'Y'
1676: cr.org_id OrgId
1677: FROM ar_cash_receipt_history crh,
1678: ar_cash_receipts cr,
1679: hz_cust_accounts cust,
1680: ar_lookups l_cat,
1681: ar_distributions d
1682: WHERE crh.gl_date BETWEEN p_Report.GlDateFrom
1683: AND p_Report.GLDateTo
1684: AND crh.postable_flag = 'Y'
1845: l_cat.meaning CatMeaning,
1846: cr.org_id OrgId
1847: FROM ar_misc_cash_distributions mcd,
1848: ar_cash_receipts cr,
1849: ar_lookups l_cat
1850: WHERE mcd.gl_date BETWEEN p_Report.GlDateFrom
1851: AND p_Report.GLDateTo
1852: AND cr.cash_receipt_id = mcd.cash_receipt_id
1853: AND l_cat.lookup_type = 'ARRGTA_FUNCTION_MAPPING'