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 544: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1064: IF p_co_seg_low IS NULL AND p_co_seg_high IS NULL THEN
1065: l_co_seg_where := NULL;
1066: ELSIF p_co_seg_low IS NULL THEN
1067: l_co_seg_where := ' AND ' ||
1068: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
1069: p_id_flex_code => 'GL#',
1070: p_id_flex_num => l_coa_id,
1071: p_table_alias => 'GC',
1072: p_mode => 'WHERE',

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

1074: p_function => '<=',
1075: p_operand1 => p_co_seg_high);
1076: ELSIF p_co_seg_high IS NULL THEN
1077: l_co_seg_where := ' AND ' ||
1078: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
1079: p_id_flex_code => 'GL#',
1080: p_id_flex_num => l_coa_id,
1081: p_table_alias => 'GC',
1082: p_mode => 'WHERE',

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

1084: p_function => '>=',
1085: p_operand1 => p_co_seg_low);
1086: ELSE
1087: l_co_seg_where := ' AND ' ||
1088: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
1089: p_id_flex_code => 'GL#',
1090: p_id_flex_num => l_coa_id,
1091: p_table_alias => 'GC',
1092: p_mode => 'WHERE',

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

1122: l_gl_date_closed_where := 'and ps.gl_date_closed >= arp_recon_rep.get_gl_date_to()';
1123: END IF;
1124:
1125: IF p_gl_account_low IS NOT NULL AND p_gl_account_high IS NOT NULL THEN
1126: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(
1127: p_application_id=> 101,
1128: p_id_flex_code =>'GL#',
1129: p_id_flex_num =>l_coa_id,
1130: p_table_alias => 'gc',

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

1239: bat.name batch_name,
1240: l_cat.meaning category,
1241: /* 7008877 */
1242: ard.line_id,
1243: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1244: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1245: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1246: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1247: ar_receipt_methods arm,

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

1240: l_cat.meaning category,
1241: /* 7008877 */
1242: ard.line_id,
1243: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1244: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1245: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1246: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1247: ar_receipt_methods arm,
1248: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

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

1241: /* 7008877 */
1242: ard.line_id,
1243: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1244: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1245: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1246: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1247: ar_receipt_methods arm,
1248: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1249: gl_code_combinations gc,

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

1335: bat.name batch_name,
1336: l_cat.meaning category,
1337: /* 7008877 */
1338: ard.line_id,
1339: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1340: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1341: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1342: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1343: ar_receipt_methods arm,

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

1336: l_cat.meaning category,
1337: /* 7008877 */
1338: ard.line_id,
1339: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1340: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1341: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1342: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1343: ar_receipt_methods arm,
1344: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

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

1337: /* 7008877 */
1338: ard.line_id,
1339: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1340: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1341: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1342: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1343: ar_receipt_methods arm,
1344: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1345: gl_code_combinations gc,

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

1407: bat.name batch_name,
1408: l_cat.meaning category,
1409: /* 7008877 */
1410: ard.line_id,
1411: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1412: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1413: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1414: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1415: ar_receipt_methods arm,

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

1408: l_cat.meaning category,
1409: /* 7008877 */
1410: ard.line_id,
1411: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1412: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1413: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1414: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1415: ar_receipt_methods arm,
1416: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

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

1409: /* 7008877 */
1410: ard.line_id,
1411: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1412: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1413: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1414: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1415: ar_receipt_methods arm,
1416: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1417: gl_code_combinations gc,

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

1489: bat.name batch_name,
1490: l_cat.meaning category,
1491: /* 7008877 */
1492: ard.line_id,
1493: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1494: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1495: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1496: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1497: ar_receipt_methods arm,

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

1490: l_cat.meaning category,
1491: /* 7008877 */
1492: ard.line_id,
1493: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1494: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1495: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1496: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1497: ar_receipt_methods arm,
1498: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

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

1491: /* 7008877 */
1492: ard.line_id,
1493: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1494: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1495: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1496: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1497: ar_receipt_methods arm,
1498: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1499: gl_code_combinations gc,

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

1580: bat.name batch_name,
1581: l_cat.meaning category,
1582: /* 7008877 */
1583: ard.line_id,
1584: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1585: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1586: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1587: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1588: ar_receipt_methods arm,

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

1581: l_cat.meaning category,
1582: /* 7008877 */
1583: ard.line_id,
1584: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1585: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1586: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1587: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1588: ar_receipt_methods arm,
1589: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

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

1582: /* 7008877 */
1583: ard.line_id,
1584: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1585: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1586: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1587: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1588: ar_receipt_methods arm,
1589: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1590: gl_code_combinations gc,

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

1652: bat.name batch_name,
1653: l_cat.meaning category,
1654: /* 7008877 */
1655: ard.line_id,
1656: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1657: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1658: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1659: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1660: ar_receipt_methods arm,

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

1653: l_cat.meaning category,
1654: /* 7008877 */
1655: ard.line_id,
1656: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1657: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1658: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1659: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1660: ar_receipt_methods arm,
1661: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

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

1654: /* 7008877 */
1655: ard.line_id,
1656: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1657: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1658: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1659: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1660: ar_receipt_methods arm,
1661: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1662: gl_code_combinations gc,

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

1749: bat.name batch_name,
1750: l_cat.meaning category,
1751: /* 7008877 */
1752: ard.line_id,
1753: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1754: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1755: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1756: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1757: ar_receipt_methods arm,

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

1750: l_cat.meaning category,
1751: /* 7008877 */
1752: ard.line_id,
1753: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1754: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1755: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1756: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1757: ar_receipt_methods arm,
1758: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

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

1751: /* 7008877 */
1752: ard.line_id,
1753: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1754: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1755: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1756: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1757: ar_receipt_methods arm,
1758: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1759: gl_code_combinations gc,

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

1819: bat.name batch_name,
1820: l_cat.meaning category,
1821: /* 7008877 */
1822: ard.line_id,
1823: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1824: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1825: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1826: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1827: ar_receipt_methods arm,

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

1820: l_cat.meaning category,
1821: /* 7008877 */
1822: ard.line_id,
1823: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1824: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1825: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1826: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1827: ar_receipt_methods arm,
1828: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

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

1821: /* 7008877 */
1822: ard.line_id,
1823: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1824: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1825: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1826: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1827: ar_receipt_methods arm,
1828: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1829: gl_code_combinations gc,

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

2282: IF p_co_seg_low IS NULL AND p_co_seg_high IS NULL THEN
2283: l_co_seg_where := NULL;
2284: ELSIF p_co_seg_low IS NULL THEN
2285: l_co_seg_where := ' AND ' ||
2286: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
2287: p_id_flex_code => 'GL#',
2288: p_id_flex_num => l_coa_id,
2289: p_table_alias => 'GC',
2290: p_mode => 'WHERE',

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

2292: p_function => '<=',
2293: p_operand1 => p_co_seg_high);
2294: ELSIF p_co_seg_high IS NULL THEN
2295: l_co_seg_where := ' AND ' ||
2296: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
2297: p_id_flex_code => 'GL#',
2298: p_id_flex_num => l_coa_id,
2299: p_table_alias => 'GC',
2300: p_mode => 'WHERE',

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

2302: p_function => '>=',
2303: p_operand1 => p_co_seg_low);
2304: ELSE
2305: l_co_seg_where := ' AND ' ||
2306: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
2307: p_id_flex_code => 'GL#',
2308: p_id_flex_num => l_coa_id,
2309: p_table_alias => 'GC',
2310: p_mode => 'WHERE',

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

2329: l_gl_date_ard_where := ' and hd.accounting_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
2330: END IF;
2331:
2332: IF p_gl_account_low IS NOT NULL AND p_gl_account_high IS NOT NULL THEN
2333: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(
2334: p_application_id=> 101,
2335: p_id_flex_code =>'GL#',
2336: p_id_flex_num =>l_coa_id,
2337: p_table_alias => 'gc',

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

2482: bs.name receipt_source,
2483: bat.name batch_name,
2484: l_cat.meaning category,
2485: ard.currency_code currency_code,
2486: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2487: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2488: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2489: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2490: ar_receipt_methods arm,

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

2483: bat.name batch_name,
2484: l_cat.meaning category,
2485: ard.currency_code currency_code,
2486: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2487: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2488: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2489: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2490: ar_receipt_methods arm,
2491: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

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

2484: l_cat.meaning category,
2485: ard.currency_code currency_code,
2486: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2487: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2488: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2489: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2490: ar_receipt_methods arm,
2491: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
2492: gl_code_combinations gc,

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

2586: bs.name receipt_source,
2587: bat.name batch_name,
2588: l_cat.meaning category,
2589: ard.currency_code currency_code,
2590: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2591: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2592: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2593: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2594: ar_receipt_methods arm,

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

2587: bat.name batch_name,
2588: l_cat.meaning category,
2589: ard.currency_code currency_code,
2590: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2591: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2592: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2593: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2594: ar_receipt_methods arm,
2595: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

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

2588: l_cat.meaning category,
2589: ard.currency_code currency_code,
2590: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2591: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2592: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2593: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2594: ar_receipt_methods arm,
2595: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
2596: gl_code_combinations gc,

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

2660: bs.name receipt_source,
2661: bat.name batch_name,
2662: l_cat.meaning category,
2663: ard.currency_code currency_code,
2664: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2665: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2666: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2667: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2668: ar_receipt_methods arm,

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

2661: bat.name batch_name,
2662: l_cat.meaning category,
2663: ard.currency_code currency_code,
2664: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2665: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2666: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2667: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2668: ar_receipt_methods arm,
2669: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

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

2662: l_cat.meaning category,
2663: ard.currency_code currency_code,
2664: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2665: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2666: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2667: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2668: ar_receipt_methods arm,
2669: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
2670: gl_code_combinations gc,

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

2745: bs.name receipt_source,
2746: bat.name batch_name,
2747: l_cat.meaning category,
2748: ard.currency_code currency_code,
2749: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2750: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2751: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2752: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2753: ar_receipt_methods arm,

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

2746: bat.name batch_name,
2747: l_cat.meaning category,
2748: ard.currency_code currency_code,
2749: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2750: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2751: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2752: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2753: ar_receipt_methods arm,
2754: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

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

2747: l_cat.meaning category,
2748: ard.currency_code currency_code,
2749: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2750: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2751: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2752: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2753: ar_receipt_methods arm,
2754: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
2755: gl_code_combinations gc,

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

2849: bs.name receipt_source,
2850: bat.name batch_name,
2851: l_cat.meaning category,
2852: ard.currency_code currency_code,
2853: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2854: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2855: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2856: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2857: ar_receipt_methods arm,

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

2850: bat.name batch_name,
2851: l_cat.meaning category,
2852: ard.currency_code currency_code,
2853: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2854: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2855: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2856: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2857: ar_receipt_methods arm,
2858: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

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

2851: l_cat.meaning category,
2852: ard.currency_code currency_code,
2853: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2854: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2855: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2856: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2857: ar_receipt_methods arm,
2858: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
2859: gl_code_combinations gc,

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

2923: bs.name receipt_source,
2924: bat.name batch_name,
2925: l_cat.meaning category,
2926: ard.currency_code currency_code,
2927: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2928: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2929: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2930: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2931: ar_receipt_methods arm,

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

2924: bat.name batch_name,
2925: l_cat.meaning category,
2926: ard.currency_code currency_code,
2927: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2928: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2929: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2930: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2931: ar_receipt_methods arm,
2932: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

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

2925: l_cat.meaning category,
2926: ard.currency_code currency_code,
2927: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2928: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2929: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2930: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
2931: ar_receipt_methods arm,
2932: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
2933: gl_code_combinations gc,

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

3352: IF p_co_seg_low IS NULL AND p_co_seg_high IS NULL THEN
3353: l_co_seg_where := NULL;
3354: ELSIF p_co_seg_low IS NULL THEN
3355: l_co_seg_where := ' AND ' ||
3356: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
3357: p_id_flex_code => 'GL#',
3358: p_id_flex_num => l_coa_id,
3359: p_table_alias => 'GC',
3360: p_mode => 'WHERE',

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

3362: p_function => '<=',
3363: p_operand1 => p_co_seg_high);
3364: ELSIF p_co_seg_high IS NULL THEN
3365: l_co_seg_where := ' AND ' ||
3366: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
3367: p_id_flex_code => 'GL#',
3368: p_id_flex_num => l_coa_id,
3369: p_table_alias => 'GC',
3370: p_mode => 'WHERE',

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

3372: p_function => '>=',
3373: p_operand1 => p_co_seg_low);
3374: ELSE
3375: l_co_seg_where := ' AND ' ||
3376: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
3377: p_id_flex_code => 'GL#',
3378: p_id_flex_num => l_coa_id,
3379: p_table_alias => 'GC',
3380: p_mode => 'WHERE',

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

3394: l_gl_date_where := ' and ra.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
3395: END IF;
3396:
3397: IF p_gl_account_low IS NOT NULL AND p_gl_account_high IS NOT NULL THEN
3398: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(
3399: p_application_id=> 101,
3400: p_id_flex_code =>'GL#',
3401: p_id_flex_num =>l_coa_id,
3402: p_table_alias => 'gc',

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

3484: to_char(ps1.exchange_date,''YYYY-MM-DD'') trx_exchange_date,
3485: ps.exchange_rate cm_exchange_rate,
3486: ps1.exchange_rate trx_exchange_rate,
3487: l_cat.meaning category,
3488: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
3489: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
3490: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
3491: from '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra ,
3492: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard ,

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

3485: ps.exchange_rate cm_exchange_rate,
3486: ps1.exchange_rate trx_exchange_rate,
3487: l_cat.meaning category,
3488: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
3489: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
3490: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
3491: from '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra ,
3492: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard ,
3493: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps ,

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

3486: ps1.exchange_rate trx_exchange_rate,
3487: l_cat.meaning category,
3488: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
3489: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
3490: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
3491: from '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra ,
3492: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard ,
3493: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps ,
3494: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps1 ,

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

3785: IF p_co_seg_low IS NULL AND p_co_seg_high IS NULL THEN
3786: l_co_seg_where := NULL;
3787: ELSIF p_co_seg_low IS NULL THEN
3788: l_co_seg_where := ' AND ' ||
3789: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
3790: p_id_flex_code => 'GL#',
3791: p_id_flex_num => p_coa_id,
3792: p_table_alias => 'GC',
3793: p_mode => 'WHERE',

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

3795: p_function => '<=',
3796: p_operand1 => p_co_seg_high);
3797: ELSIF p_co_seg_high IS NULL THEN
3798: l_co_seg_where := ' AND ' ||
3799: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
3800: p_id_flex_code => 'GL#',
3801: p_id_flex_num => p_coa_id,
3802: p_table_alias => 'GC',
3803: p_mode => 'WHERE',

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

3805: p_function => '>=',
3806: p_operand1 => p_co_seg_low);
3807: ELSE
3808: l_co_seg_where := ' AND ' ||
3809: AR_CALC_AGING.FLEX_SQL(p_application_id => 101,
3810: p_id_flex_code => 'GL#',
3811: p_id_flex_num => p_coa_id,
3812: p_table_alias => 'GC',
3813: p_mode => 'WHERE',

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

3817: p_operand2 => p_co_seg_high);
3818: END IF;
3819:
3820: IF p_gl_account_low IS NOT NULL AND p_gl_account_high IS NOT NULL THEN
3821: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(
3822: p_application_id=> 101,
3823: p_id_flex_code =>'GL#',
3824: p_id_flex_num =>p_coa_id,
3825: p_table_alias => 'gc',

Line 3909: l_sel_seg := ar_calc_aging.flex_sql(

3905: END IF;
3906:
3907: --9671956
3908:
3909: l_sel_seg := ar_calc_aging.flex_sql(
3910: 101,
3911: 'GL#',
3912: p_coa_id,
3913: 'gc',

Line 3917: l_sel_co_seg := ar_calc_aging.flex_sql(

3913: 'gc',
3914: 'SELECT',
3915: 'ALL');
3916:
3917: l_sel_co_seg := ar_calc_aging.flex_sql(
3918: 101,
3919: 'GL#',
3920: p_coa_id,
3921: 'gc',

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

4749: /* Commented for bug 10177944, the length of the column 'account_desc' in the table
4750: 'ar_gl_recon_gt' is 240, but the return value's length can up to 2000, so cut the
4751: description of it's more than 240./*
4752: /*update ar_gl_recon_gt
4753: set account_desc = ar_calc_aging.get_description (101,'GL#',
4754: arp_recon_rep.get_chart_of_accounts_id(),'GL_ACCOUNT',code_combination_id);*/
4755:
4756:
4757: -- Fix for bug 16357135 .. pass "code_combination_id" in place of