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.ARP_RECON_REP dependencies on AR_CALC_AGING

Line 543: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,

539: IF p_co_seg_low IS NULL AND p_co_seg_high IS NULL THEN
540: l_co_seg_where := NULL;
541: ELSIF p_co_seg_low IS NULL THEN
542: l_co_seg_where := ' AND ' ||
543: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
544: p_id_flex_code => 'GL#',
545: p_id_flex_num => l_coa_id,
546: p_table_alias => 'GC',
547: p_mode => 'WHERE',

Line 553: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,

549: p_function => '<=',
550: p_operand1 => p_co_seg_high);
551: ELSIF p_co_seg_high IS NULL THEN
552: l_co_seg_where := ' AND ' ||
553: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
554: p_id_flex_code => 'GL#',
555: p_id_flex_num => l_coa_id,
556: p_table_alias => 'GC',
557: p_mode => 'WHERE',

Line 563: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,

559: p_function => '>=',
560: p_operand1 => p_co_seg_low);
561: ELSE
562: l_co_seg_where := ' AND ' ||
563: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
564: p_id_flex_code => 'GL#',
565: p_id_flex_num => l_coa_id,
566: p_table_alias => 'GC',
567: p_mode => 'WHERE',

Line 585: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(

581: l_gl_date_where := ' and adj.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
582: END IF;
583:
584: IF p_gl_account_low IS NOT NULL AND p_gl_account_high IS NOT NULL THEN
585: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(
586: p_application_id=> 101,
587: p_id_flex_code =>'GL#',
588: p_id_flex_num =>l_coa_id,
589: p_table_alias => 'gc',

Line 675: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,

671: nvl(ard.acctd_amount_dr,0) acctd_debit,
672: nvl(ard.acctd_amount_cr,0) acctd_credit,
673: gc.code_combination_id account_code_combination_id,
674: l_cat.meaning category,
675: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
676: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
677: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
678: from hz_cust_accounts cust,
679: hz_parties party,

Line 676: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,

672: nvl(ard.acctd_amount_cr,0) acctd_credit,
673: gc.code_combination_id account_code_combination_id,
674: l_cat.meaning category,
675: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
676: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
677: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
678: from hz_cust_accounts cust,
679: hz_parties party,
680: ra_cust_trx_types_all type,

Line 677: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc

673: gc.code_combination_id account_code_combination_id,
674: l_cat.meaning category,
675: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
676: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
677: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
678: from hz_cust_accounts cust,
679: hz_parties party,
680: ra_cust_trx_types_all type,
681: gl_code_combinations gc,

Line 1052: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,

1048: IF p_co_seg_low IS NULL AND p_co_seg_high IS NULL THEN
1049: l_co_seg_where := NULL;
1050: ELSIF p_co_seg_low IS NULL THEN
1051: l_co_seg_where := ' AND ' ||
1052: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
1053: p_id_flex_code => 'GL#',
1054: p_id_flex_num => l_coa_id,
1055: p_table_alias => 'GC',
1056: p_mode => 'WHERE',

Line 1062: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,

1058: p_function => '<=',
1059: p_operand1 => p_co_seg_high);
1060: ELSIF p_co_seg_high IS NULL THEN
1061: l_co_seg_where := ' AND ' ||
1062: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
1063: p_id_flex_code => 'GL#',
1064: p_id_flex_num => l_coa_id,
1065: p_table_alias => 'GC',
1066: p_mode => 'WHERE',

Line 1072: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,

1068: p_function => '>=',
1069: p_operand1 => p_co_seg_low);
1070: ELSE
1071: l_co_seg_where := ' AND ' ||
1072: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
1073: p_id_flex_code => 'GL#',
1074: p_id_flex_num => l_coa_id,
1075: p_table_alias => 'GC',
1076: p_mode => 'WHERE',

Line 1107: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(

1103: l_gl_date_closed_where := 'and ps.gl_date_closed >= arp_recon_rep.get_gl_date_to()';
1104: END IF;
1105:
1106: IF p_gl_account_low IS NOT NULL AND p_gl_account_high IS NOT NULL THEN
1107: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(
1108: p_application_id=> 101,
1109: p_id_flex_code =>'GL#',
1110: p_id_flex_num =>l_coa_id,
1111: p_table_alias => 'gc',

Line 1205: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,

1201: bat.name batch_name,
1202: l_cat.meaning category,
1203: /* 7008877 */
1204: ard.line_id,
1205: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1206: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1207: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1208: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1209: ar_receipt_methods arm,

Line 1206: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,

1202: l_cat.meaning category,
1203: /* 7008877 */
1204: ard.line_id,
1205: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1206: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1207: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1208: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1209: ar_receipt_methods arm,
1210: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

Line 1207: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc

1203: /* 7008877 */
1204: ard.line_id,
1205: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1206: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1207: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1208: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1209: ar_receipt_methods arm,
1210: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1211: gl_code_combinations gc,

Line 1273: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,

1269: bat.name batch_name,
1270: l_cat.meaning category,
1271: /* 7008877 */
1272: ard.line_id,
1273: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1274: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1275: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1276: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1277: ar_receipt_methods arm,

Line 1274: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,

1270: l_cat.meaning category,
1271: /* 7008877 */
1272: ard.line_id,
1273: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1274: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1275: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1276: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1277: ar_receipt_methods arm,
1278: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

Line 1275: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc

1271: /* 7008877 */
1272: ard.line_id,
1273: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1274: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1275: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1276: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1277: ar_receipt_methods arm,
1278: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1279: gl_code_combinations gc,

Line 1646: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,

1642: IF p_co_seg_low IS NULL AND p_co_seg_high IS NULL THEN
1643: l_co_seg_where := NULL;
1644: ELSIF p_co_seg_low IS NULL THEN
1645: l_co_seg_where := ' AND ' ||
1646: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
1647: p_id_flex_code => 'GL#',
1648: p_id_flex_num => l_coa_id,
1649: p_table_alias => 'GC',
1650: p_mode => 'WHERE',

Line 1656: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,

1652: p_function => '<=',
1653: p_operand1 => p_co_seg_high);
1654: ELSIF p_co_seg_high IS NULL THEN
1655: l_co_seg_where := ' AND ' ||
1656: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
1657: p_id_flex_code => 'GL#',
1658: p_id_flex_num => l_coa_id,
1659: p_table_alias => 'GC',
1660: p_mode => 'WHERE',

Line 1666: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,

1662: p_function => '>=',
1663: p_operand1 => p_co_seg_low);
1664: ELSE
1665: l_co_seg_where := ' AND ' ||
1666: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
1667: p_id_flex_code => 'GL#',
1668: p_id_flex_num => l_coa_id,
1669: p_table_alias => 'GC',
1670: p_mode => 'WHERE',

Line 1689: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(

1685: l_gl_date_where := ' and ra.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
1686: END IF;
1687:
1688: IF p_gl_account_low IS NOT NULL AND p_gl_account_high IS NOT NULL THEN
1689: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(
1690: p_application_id=> 101,
1691: p_id_flex_code =>'GL#',
1692: p_id_flex_num =>l_coa_id,
1693: p_table_alias => 'gc',

Line 1787: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,

1783: bs.name receipt_source,
1784: bat.name batch_name,
1785: l_cat.meaning category,
1786: ard.currency_code currency_code,
1787: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1788: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1789: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1790: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1791: ar_receipt_methods arm,

Line 1788: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,

1784: bat.name batch_name,
1785: l_cat.meaning category,
1786: ard.currency_code currency_code,
1787: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1788: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1789: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1790: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1791: ar_receipt_methods arm,
1792: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

Line 1789: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc

1785: l_cat.meaning category,
1786: ard.currency_code currency_code,
1787: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1788: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1789: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1790: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1791: ar_receipt_methods arm,
1792: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1793: gl_code_combinations gc,

Line 2143: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,

2139: IF p_co_seg_low IS NULL AND p_co_seg_high IS NULL THEN
2140: l_co_seg_where := NULL;
2141: ELSIF p_co_seg_low IS NULL THEN
2142: l_co_seg_where := ' AND ' ||
2143: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
2144: p_id_flex_code => 'GL#',
2145: p_id_flex_num => l_coa_id,
2146: p_table_alias => 'GC',
2147: p_mode => 'WHERE',

Line 2153: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,

2149: p_function => '<=',
2150: p_operand1 => p_co_seg_high);
2151: ELSIF p_co_seg_high IS NULL THEN
2152: l_co_seg_where := ' AND ' ||
2153: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
2154: p_id_flex_code => 'GL#',
2155: p_id_flex_num => l_coa_id,
2156: p_table_alias => 'GC',
2157: p_mode => 'WHERE',

Line 2163: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,

2159: p_function => '>=',
2160: p_operand1 => p_co_seg_low);
2161: ELSE
2162: l_co_seg_where := ' AND ' ||
2163: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
2164: p_id_flex_code => 'GL#',
2165: p_id_flex_num => l_coa_id,
2166: p_table_alias => 'GC',
2167: p_mode => 'WHERE',

Line 2185: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(

2181: l_gl_date_where := ' and ra.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
2182: END IF;
2183:
2184: IF p_gl_account_low IS NOT NULL AND p_gl_account_high IS NOT NULL THEN
2185: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(
2186: p_application_id=> 101,
2187: p_id_flex_code =>'GL#',
2188: p_id_flex_num =>l_coa_id,
2189: p_table_alias => 'gc',

Line 2275: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,

2271: to_char(ps1.exchange_date,''YYYY-MM-DD'') trx_exchange_date,
2272: ps.exchange_rate cm_exchange_rate,
2273: ps1.exchange_rate trx_exchange_rate,
2274: l_cat.meaning category,
2275: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2276: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2277: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2278: from '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra ,
2279: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard ,

Line 2276: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,

2272: ps.exchange_rate cm_exchange_rate,
2273: ps1.exchange_rate trx_exchange_rate,
2274: l_cat.meaning category,
2275: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2276: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2277: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2278: from '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra ,
2279: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard ,
2280: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps ,

Line 2277: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc

2273: ps1.exchange_rate trx_exchange_rate,
2274: l_cat.meaning category,
2275: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2276: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2277: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2278: from '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra ,
2279: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard ,
2280: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps ,
2281: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps1 ,

Line 2562: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,

2558: IF p_co_seg_low IS NULL AND p_co_seg_high IS NULL THEN
2559: l_co_seg_where := NULL;
2560: ELSIF p_co_seg_low IS NULL THEN
2561: l_co_seg_where := ' AND ' ||
2562: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
2563: p_id_flex_code => 'GL#',
2564: p_id_flex_num => p_coa_id,
2565: p_table_alias => 'GC',
2566: p_mode => 'WHERE',

Line 2572: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,

2568: p_function => '<=',
2569: p_operand1 => p_co_seg_high);
2570: ELSIF p_co_seg_high IS NULL THEN
2571: l_co_seg_where := ' AND ' ||
2572: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
2573: p_id_flex_code => 'GL#',
2574: p_id_flex_num => p_coa_id,
2575: p_table_alias => 'GC',
2576: p_mode => 'WHERE',

Line 2582: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,

2578: p_function => '>=',
2579: p_operand1 => p_co_seg_low);
2580: ELSE
2581: l_co_seg_where := ' AND ' ||
2582: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
2583: p_id_flex_code => 'GL#',
2584: p_id_flex_num => p_coa_id,
2585: p_table_alias => 'GC',
2586: p_mode => 'WHERE',

Line 2594: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(

2590: p_operand2 => p_co_seg_high);
2591: END IF;
2592:
2593: IF p_gl_account_low IS NOT NULL AND p_gl_account_high IS NOT NULL THEN
2594: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(
2595: p_application_id=> 101,
2596: p_id_flex_code =>'GL#',
2597: p_id_flex_num =>p_coa_id,
2598: p_table_alias => 'gc',

Line 2980: set account = ar_calc_aging.get_value(101,'GL#',

2976: and gif.actual_flag = 'A'
2977: group by gif.code_combination_id);
2978:
2979: update ar_gl_recon_gt
2980: set account = ar_calc_aging.get_value(101,'GL#',
2981: arp_recon_rep.get_chart_of_accounts_id(),'ALL',code_combination_id),
2982: company = ar_calc_aging.get_value(101,'GL#',
2983: arp_recon_rep.get_chart_of_accounts_id(),'GL_BALANCING',code_combination_id),
2984: account_desc = ar_calc_aging.get_description(101,'GL#',

Line 2982: company = ar_calc_aging.get_value(101,'GL#',

2978:
2979: update ar_gl_recon_gt
2980: set account = ar_calc_aging.get_value(101,'GL#',
2981: arp_recon_rep.get_chart_of_accounts_id(),'ALL',code_combination_id),
2982: company = ar_calc_aging.get_value(101,'GL#',
2983: arp_recon_rep.get_chart_of_accounts_id(),'GL_BALANCING',code_combination_id),
2984: account_desc = ar_calc_aging.get_description(101,'GL#',
2985: arp_recon_rep.get_chart_of_accounts_id(),'GL_ACCOUNT',code_combination_id);
2986:

Line 2984: account_desc = ar_calc_aging.get_description(101,'GL#',

2980: set account = ar_calc_aging.get_value(101,'GL#',
2981: arp_recon_rep.get_chart_of_accounts_id(),'ALL',code_combination_id),
2982: company = ar_calc_aging.get_value(101,'GL#',
2983: arp_recon_rep.get_chart_of_accounts_id(),'GL_BALANCING',code_combination_id),
2984: account_desc = ar_calc_aging.get_description(101,'GL#',
2985: arp_recon_rep.get_chart_of_accounts_id(),'GL_ACCOUNT',code_combination_id);
2986:
2987: l_xml_query := '
2988: select code_combination_id,

Line 3016: ar_calc_aging.get_value(101,''GL#'',

3012: or nvl(receivables_dr,0)- nvl(subledger_rec_dr,0) <> 0
3013: or nvl(receivables_cr,0)- nvl(subledger_rec_cr,0) <> 0
3014: order by account_type_code,
3015: company,
3016: ar_calc_aging.get_value(101,''GL#'',
3017: arp_recon_rep.get_chart_of_accounts_id(),
3018: ''GL_ACCOUNT'',code_combination_id)';
3019:
3020: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);