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.IEX_CUST_OVERVIEW_PVT dependencies on AR_SYSTEM_PARAMETERS

Line 650: ar_system_parameters sp

646: -- Begin fix bug #5261855-jypark-06/16/2006-change to based table for performance
647: -- iex_delinquencies del,
648: iex_delinquencies_all del,
649: -- End fix bug #5261855-jypark-06/16/2006-change to based table for performance
650: ar_system_parameters sp
651: WHERE ca.party_id = l_party_id
652: AND ps.customer_id = ca.cust_account_id
653: AND ps.status = 'OP'
654: AND del.payment_schedule_id(+) = ps.payment_schedule_id

Line 676: ar_system_parameters sp

672: 'PREDELINQUENT', NVL(acctd_amount_due_remaining,0),0)) overdue_amt
673: FROM ar_payment_schedules ps,
674: hz_cust_accounts ca,
675: iex_delinquencies_all del,
676: ar_system_parameters sp
677: WHERE ca.party_id = l_party_id
678: AND ps.customer_id = ca.cust_account_id
679: AND ps.status = 'OP'
680: AND del.payment_schedule_id(+) = ps.payment_schedule_id

Line 757: ar_system_parameters parm

753: into l_amount_in_dispute
754: from ra_cm_requests cm
755: where cm.customer_trx_id in (select distinct ps.customer_trx_id
756: from ar_payment_schedules ps,
757: ar_system_parameters parm
758: where ps.customer_id = p_object_id
759: and ps.org_id = parm.org_id
760: and ps.status = 'OP')
761: and cm.status='PENDING_APPROVAL'

Line 773: ar_system_parameters parm

769: OPEN c_balance FOR
770: SELECT SUM(NVL(acctd_amount_due_remaining,0))
771: FROM ar_payment_schedules ps,
772: -- Begin fix bug #5077320-jypark-adding parameter table to show amount for selected operating unit
773: ar_system_parameters parm
774: WHERE customer_id = p_object_id
775: AND ps.org_id = parm.org_id
776: -- End fix bug #5077320-jypark-adding parameter table to show amount for selected operating unit
777: AND ps.status = 'OP';

Line 819: /* FROM ar_system_parameters sp,

815: -1, (PS.AMOUNT_DUE_ORIGINAL + NVL(PS.AMOUNT_ADJUSTED,0)) * NVL(PS.EXCHANGE_RATE, 1 ),
816: 0) )
817: )
818: ), 0) /* DSO */
819: /* FROM ar_system_parameters sp,
820: ar_payment_schedules ps
821: WHERE ps.customer_id = l_cust_account_id
822: AND NVL(ps.receipt_confirmed_flag,'Y') = 'Y'
823: AND ps.org_id=sp.org_id; --added for moac change

Line 926: FROM ar_system_parameters sp,

922: -1, (PS.AMOUNT_DUE_ORIGINAL + NVL(PS.AMOUNT_ADJUSTED,0)) * NVL(PS.EXCHANGE_RATE, 1 ),
923: 0) )
924: )
925: ), 0) /* DSO */
926: FROM ar_system_parameters sp,
927: ar_payment_schedules ps
928: WHERE NVL(ps.receipt_confirmed_flag,'Y') = 'Y'
929: AND ps.payment_schedule_id = l_payment_schedule_id
930: AND ps.org_id=sp.org_id; --added for moac change

Line 974: ar_system_parameters parm

970: into l_amount_in_dispute
971: from ra_cm_requests cm
972: where cm.customer_trx_id in (select distinct ps.customer_trx_id
973: FROM ar_payment_schedules ps,
974: ar_system_parameters parm
975: WHERE ps.customer_site_use_id = p_object_id
976: AND ps.org_id = parm.org_id
977: AND ps.status = 'OP')
978: and cm.status='PENDING_APPROVAL';

Line 988: ar_system_parameters parm

984: OPEN c_balance FOR
985: SELECT SUM(NVL(acctd_amount_due_remaining,0))
986: FROM ar_payment_schedules ps,
987: -- Begin fix bug #5077320-jypark-adding parameter table to show amount for selected operating unit
988: ar_system_parameters parm
989: WHERE customer_site_use_id = p_object_id
990: AND ps.org_id = parm.org_id
991: AND status = 'OP';
992: -- SELECT SUM(DECODE(class, 'INV', acctd_amount_due_remaining,

Line 1043: /* FROM ar_system_parameters sp,

1039: -1, (PS.AMOUNT_DUE_ORIGINAL + NVL(PS.AMOUNT_ADJUSTED,0)) * NVL(PS.EXCHANGE_RATE, 1 ),
1040: 0) )
1041: )
1042: ), 0) /* DSO */
1043: /* FROM ar_system_parameters sp,
1044: ar_payment_schedules ps
1045: WHERE ps.customer_site_use_id = l_customer_site_use_id
1046: AND NVL(ps.receipt_confirmed_flag,'Y') = 'Y'
1047: AND ps.org_id=sp.org_id; --added for moac change

Line 1203: l_pk_from := l_pk_from || ', ar_system_parameters arsys ';

1199: l_pk_where := 'where ca.CUST_ACCOUNT_ID = TRX_SUM.CUST_ACCOUNT_ID ';
1200: l_pk_group := 'group by ca.party_id, TRX_SUM.CUST_ACCOUNT_ID, TRX_SUM.SITE_USE_ID, TRX_SUM.ORG_ID, TRX_SUM.CURRENCY ';
1201:
1202: -- Begin - Bug#5358461 - Andre Araujo - 07/07/06 - This query is not MOAC ready
1203: l_pk_from := l_pk_from || ', ar_system_parameters arsys ';
1204: l_pk_where := l_pk_where || ' AND arsys.org_id = trx_sum.org_id ';
1205: l_pk_group := l_pk_group || ' order by pay_date desc '; -- To do this pay_date was added to the end of l_pk_query
1206: -- End - Bug#5358461 - Andre Araujo - 07/07/06 - This query is not MOAC ready
1207:

Line 1960: ar_system_parameters sp

1956: ), 0) dso
1957: FROM ar_payment_schedules ps,
1958: hz_cust_accounts ca,
1959: iex_delinquencies del,
1960: ar_system_parameters sp
1961: WHERE ca.party_id = p_party_id
1962: AND ps.customer_id = ca.cust_account_id
1963: AND ps.status = 'OP'
1964: AND del.payment_schedule_id(+) = ps.payment_schedule_id

Line 2019: ar_system_parameters sp

2015: ), 0) dso
2016: FROM ar_payment_schedules ps,
2017: hz_cust_accounts ca,
2018: iex_delinquencies del,
2019: ar_system_parameters sp
2020: WHERE ca.party_id = p_party_id
2021: AND ps.customer_id = ca.cust_account_id
2022: AND ps.status = 'OP'
2023: AND del.payment_schedule_id(+) = ps.payment_schedule_id

Line 2036: ar_system_parameters sp

2032: 'PREDELINQUENT', NVL(acctd_amount_due_remaining,0),0)) overdue_amt
2033: FROM ar_payment_schedules ps,
2034: hz_cust_accounts ca,
2035: iex_delinquencies del,
2036: ar_system_parameters sp
2037: WHERE ca.party_id = p_party_id
2038: AND ps.customer_id = ca.cust_account_id
2039: AND ps.status = 'OP'
2040: AND del.payment_schedule_id(+) = ps.payment_schedule_id