eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_ARXCCS_XMLP_PKG dependencies on AR_STATEMENT_CYCLE_DATES

Line 2126: AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,

2122: l_last_st_days_since VARCHAR2 (100);
2123:
2124: CURSOR C_STATEMENT IS
2125: SELECT AR_STATEMENT_CYCLES.NAME,
2126: AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,
2127: TRUNC(TRUNC(SYSDATE) - AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE)
2128: FROM HZ_CUSTOMER_PROFILES, AR_STATEMENT_CYCLES,
2129: AR_STATEMENT_CYCLE_DATES
2130: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =

Line 2127: TRUNC(TRUNC(SYSDATE) - AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE)

2123:
2124: CURSOR C_STATEMENT IS
2125: SELECT AR_STATEMENT_CYCLES.NAME,
2126: AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,
2127: TRUNC(TRUNC(SYSDATE) - AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE)
2128: FROM HZ_CUSTOMER_PROFILES, AR_STATEMENT_CYCLES,
2129: AR_STATEMENT_CYCLE_DATES
2130: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2131: AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID

Line 2129: AR_STATEMENT_CYCLE_DATES

2125: SELECT AR_STATEMENT_CYCLES.NAME,
2126: AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,
2127: TRUNC(TRUNC(SYSDATE) - AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE)
2128: FROM HZ_CUSTOMER_PROFILES, AR_STATEMENT_CYCLES,
2129: AR_STATEMENT_CYCLE_DATES
2130: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2131: AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID
2132: AND AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID =
2133: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID

Line 2133: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID

2129: AR_STATEMENT_CYCLE_DATES
2130: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2131: AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID
2132: AND AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID =
2133: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID
2134: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'Y'
2135: AND HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_ID = CUSTOMER_ID
2136: AND HZ_CUSTOMER_PROFILES.site_use_id = site_use_id
2137: ORDER BY AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE DESC,

Line 2134: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'Y'

2130: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2131: AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID
2132: AND AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID =
2133: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID
2134: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'Y'
2135: AND HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_ID = CUSTOMER_ID
2136: AND HZ_CUSTOMER_PROFILES.site_use_id = site_use_id
2137: ORDER BY AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE DESC,
2138: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_DATE_ID DESC ;

Line 2137: ORDER BY AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE DESC,

2133: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID
2134: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'Y'
2135: AND HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_ID = CUSTOMER_ID
2136: AND HZ_CUSTOMER_PROFILES.site_use_id = site_use_id
2137: ORDER BY AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE DESC,
2138: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_DATE_ID DESC ;
2139:
2140: CURSOR C_STATEMENT_DEFAULT IS
2141: SELECT AR_STATEMENT_CYCLES.NAME,

Line 2138: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_DATE_ID DESC ;

2134: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'Y'
2135: AND HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_ID = CUSTOMER_ID
2136: AND HZ_CUSTOMER_PROFILES.site_use_id = site_use_id
2137: ORDER BY AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE DESC,
2138: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_DATE_ID DESC ;
2139:
2140: CURSOR C_STATEMENT_DEFAULT IS
2141: SELECT AR_STATEMENT_CYCLES.NAME,
2142: AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,

Line 2142: AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,

2138: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_DATE_ID DESC ;
2139:
2140: CURSOR C_STATEMENT_DEFAULT IS
2141: SELECT AR_STATEMENT_CYCLES.NAME,
2142: AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,
2143: TRUNC(TRUNC(SYSDATE) - AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE)
2144: FROM HZ_CUSTOMER_PROFILES, AR_STATEMENT_CYCLES,
2145: AR_STATEMENT_CYCLE_DATES
2146: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =

Line 2143: TRUNC(TRUNC(SYSDATE) - AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE)

2139:
2140: CURSOR C_STATEMENT_DEFAULT IS
2141: SELECT AR_STATEMENT_CYCLES.NAME,
2142: AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,
2143: TRUNC(TRUNC(SYSDATE) - AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE)
2144: FROM HZ_CUSTOMER_PROFILES, AR_STATEMENT_CYCLES,
2145: AR_STATEMENT_CYCLE_DATES
2146: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2147: AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID

Line 2145: AR_STATEMENT_CYCLE_DATES

2141: SELECT AR_STATEMENT_CYCLES.NAME,
2142: AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,
2143: TRUNC(TRUNC(SYSDATE) - AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE)
2144: FROM HZ_CUSTOMER_PROFILES, AR_STATEMENT_CYCLES,
2145: AR_STATEMENT_CYCLE_DATES
2146: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2147: AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID
2148: AND AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID =
2149: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID

Line 2149: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID

2145: AR_STATEMENT_CYCLE_DATES
2146: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2147: AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID
2148: AND AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID =
2149: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID
2150: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'Y'
2151: AND HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_ID = CUSTOMER_ID
2152: AND HZ_CUSTOMER_PROFILES.site_use_id is null
2153: ORDER BY AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE DESC,

Line 2150: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'Y'

2146: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2147: AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID
2148: AND AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID =
2149: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID
2150: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'Y'
2151: AND HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_ID = CUSTOMER_ID
2152: AND HZ_CUSTOMER_PROFILES.site_use_id is null
2153: ORDER BY AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE DESC,
2154: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_DATE_ID DESC

Line 2153: ORDER BY AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE DESC,

2149: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID
2150: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'Y'
2151: AND HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_ID = CUSTOMER_ID
2152: AND HZ_CUSTOMER_PROFILES.site_use_id is null
2153: ORDER BY AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE DESC,
2154: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_DATE_ID DESC
2155: ;
2156:
2157: BEGIN

Line 2154: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_DATE_ID DESC

2150: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'Y'
2151: AND HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_ID = CUSTOMER_ID
2152: AND HZ_CUSTOMER_PROFILES.site_use_id is null
2153: ORDER BY AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE DESC,
2154: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_DATE_ID DESC
2155: ;
2156:
2157: BEGIN
2158:

Line 2201: SELECT MIN(AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE)

2197: DECLARE
2198: l_last_stmnt_next_trx_date VARCHAR2 (11);
2199:
2200: BEGIN
2201: SELECT MIN(AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE)
2202: INTO l_last_stmnt_next_trx_date
2203: FROM HZ_CUSTOMER_PROFILES,
2204: AR_STATEMENT_CYCLE_DATES
2205: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =

Line 2204: AR_STATEMENT_CYCLE_DATES

2200: BEGIN
2201: SELECT MIN(AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE)
2202: INTO l_last_stmnt_next_trx_date
2203: FROM HZ_CUSTOMER_PROFILES,
2204: AR_STATEMENT_CYCLE_DATES
2205: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2206: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID
2207: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'N'
2208: AND AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE > to_date(c_last_st_date,'DD-MM-YYYY')

Line 2206: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID

2202: INTO l_last_stmnt_next_trx_date
2203: FROM HZ_CUSTOMER_PROFILES,
2204: AR_STATEMENT_CYCLE_DATES
2205: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2206: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID
2207: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'N'
2208: AND AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE > to_date(c_last_st_date,'DD-MM-YYYY')
2209: AND HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_ID = CUSTOMER_ID
2210: AND HZ_CUSTOMER_PROFILES.SITE_USE_ID IS NULL

Line 2207: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'N'

2203: FROM HZ_CUSTOMER_PROFILES,
2204: AR_STATEMENT_CYCLE_DATES
2205: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2206: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID
2207: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'N'
2208: AND AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE > to_date(c_last_st_date,'DD-MM-YYYY')
2209: AND HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_ID = CUSTOMER_ID
2210: AND HZ_CUSTOMER_PROFILES.SITE_USE_ID IS NULL
2211: ORDER BY AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,

Line 2208: AND AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE > to_date(c_last_st_date,'DD-MM-YYYY')

2204: AR_STATEMENT_CYCLE_DATES
2205: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2206: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID
2207: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'N'
2208: AND AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE > to_date(c_last_st_date,'DD-MM-YYYY')
2209: AND HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_ID = CUSTOMER_ID
2210: AND HZ_CUSTOMER_PROFILES.SITE_USE_ID IS NULL
2211: ORDER BY AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,
2212: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_DATE_ID

Line 2211: ORDER BY AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,

2207: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'N'
2208: AND AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE > to_date(c_last_st_date,'DD-MM-YYYY')
2209: AND HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_ID = CUSTOMER_ID
2210: AND HZ_CUSTOMER_PROFILES.SITE_USE_ID IS NULL
2211: ORDER BY AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,
2212: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_DATE_ID
2213: ;
2214:
2215: c_last_stmnt_next_trx_date := nvl(l_last_stmnt_next_trx_date,rp_none) ;

Line 2212: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_DATE_ID

2208: AND AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE > to_date(c_last_st_date,'DD-MM-YYYY')
2209: AND HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_ID = CUSTOMER_ID
2210: AND HZ_CUSTOMER_PROFILES.SITE_USE_ID IS NULL
2211: ORDER BY AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,
2212: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_DATE_ID
2213: ;
2214:
2215: c_last_stmnt_next_trx_date := nvl(l_last_stmnt_next_trx_date,rp_none) ;
2216: EXCEPTION WHEN NO_DATA_FOUND THEN