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.ARI_UTILITIES dependencies on FND_GLOBAL

Line 615: AND AUAS.user_id=FND_GLOBAL.USER_ID()

611: CPF.SITE_USE_ID = AUAS.CUSTOMER_SITE_USE_ID
612: OR
613: CPF.SITE_USE_ID IS NULL
614: )
615: AND AUAS.user_id=FND_GLOBAL.USER_ID()
616: AND AUAS.session_id=p_session_id)
617: UNION
618: (SELECT unique ( CUR.CURRENCY_CODE ) FROM FND_CURRENCIES_VL CUR, AR_TRX_BAL_SUMMARY ATB, ar_irec_user_acct_sites_all AUAS
619: WHERE ATB.CURRENCY = CUR.CURRENCY_CODE AND

Line 622: AND AUAS.user_id=FND_GLOBAL.USER_ID()

618: (SELECT unique ( CUR.CURRENCY_CODE ) FROM FND_CURRENCIES_VL CUR, AR_TRX_BAL_SUMMARY ATB, ar_irec_user_acct_sites_all AUAS
619: WHERE ATB.CURRENCY = CUR.CURRENCY_CODE AND
620: ATB.CUST_ACCOUNT_ID = AUAS.CUSTOMER_ID AND
621: (ATB.SITE_USE_ID = AUAS.CUSTOMER_SITE_USE_ID OR ATB.SITE_USE_ID IS NULL)
622: AND AUAS.user_id=FND_GLOBAL.USER_ID()
623: AND AUAS.session_id=p_session_id));
624: if( l_currency_exist > 0 ) then
625: return l_profile_default_currrency;
626: end if;

Line 643: AND AUAS.user_id=FND_GLOBAL.USER_ID()

639: OR
640:
641: CPF.SITE_USE_ID IS NULL
642: )
643: AND AUAS.user_id=FND_GLOBAL.USER_ID()
644: AND AUAS.session_id=p_session_id
645: AND ROWNUM = 1;
646:
647: --If currency does not exist in customer profile, then check if currency exist in transactions of the customer

Line 655: AND AUAS.user_id=FND_GLOBAL.USER_ID()

651: AR_TRX_BAL_SUMMARY ATB, ar_irec_user_acct_sites_all AUAS
652: WHERE ATB.CURRENCY = CUR.CURRENCY_CODE AND
653: ATB.CUST_ACCOUNT_ID = AUAS.CUSTOMER_ID AND
654: (ATB.SITE_USE_ID = AUAS.CUSTOMER_SITE_USE_ID OR ATB.SITE_USE_ID IS NULL)
655: AND AUAS.user_id=FND_GLOBAL.USER_ID()
656: AND AUAS.session_id=p_session_id;
657: end if;
658:
659: ELSE

Line 672: AND AUAS.user_id=FND_GLOBAL.USER_ID()

668: CPF.SITE_USE_ID = AUAS.CUSTOMER_SITE_USE_ID
669: OR
670: CPF.SITE_USE_ID IS NULL
671: )
672: AND AUAS.user_id=FND_GLOBAL.USER_ID()
673: AND AUAS.session_id=p_session_id)
674: UNION
675: (SELECT unique ( CUR.CURRENCY_CODE ) FROM FND_CURRENCIES_VL CUR, AR_TRX_BAL_SUMMARY ATB, ar_irec_user_acct_sites_all AUAS
676: WHERE ATB.CURRENCY = CUR.CURRENCY_CODE AND

Line 679: AND AUAS.user_id=FND_GLOBAL.USER_ID()

675: (SELECT unique ( CUR.CURRENCY_CODE ) FROM FND_CURRENCIES_VL CUR, AR_TRX_BAL_SUMMARY ATB, ar_irec_user_acct_sites_all AUAS
676: WHERE ATB.CURRENCY = CUR.CURRENCY_CODE AND
677: ATB.CUST_ACCOUNT_ID = p_customer_id AND
678: (ATB.SITE_USE_ID = AUAS.CUSTOMER_SITE_USE_ID OR ATB.SITE_USE_ID IS NULL)
679: AND AUAS.user_id=FND_GLOBAL.USER_ID()
680: AND AUAS.session_id=p_session_id));
681:
682: if( l_currency_exist > 0 ) then
683: return l_profile_default_currrency;

Line 701: AND AUAS.user_id=FND_GLOBAL.USER_ID()

697: CPF.SITE_USE_ID = AUAS.CUSTOMER_SITE_USE_ID
698: OR
699: CPF.SITE_USE_ID IS NULL
700: )
701: AND AUAS.user_id=FND_GLOBAL.USER_ID()
702: AND AUAS.session_id=p_session_id
703: AND ROWNUM = 1;
704:
705: --If currency does not exist in customer profile, then check if currency exist in transactions of the customer

Line 713: AND AUAS.user_id=FND_GLOBAL.USER_ID()

709: AR_TRX_BAL_SUMMARY ATB, ar_irec_user_acct_sites_all AUAS
710: WHERE ATB.CURRENCY = CUR.CURRENCY_CODE AND
711: ATB.CUST_ACCOUNT_ID = p_customer_id AND
712: (ATB.SITE_USE_ID = AUAS.CUSTOMER_SITE_USE_ID OR ATB.SITE_USE_ID IS NULL)
713: AND AUAS.user_id=FND_GLOBAL.USER_ID()
714: AND AUAS.session_id=p_session_id;
715: end if;
716:
717: END IF;

Line 2115: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);

2111: arp_standard.debug ('l_resp_id ='||l_resp_id);
2112: arp_standard.debug ('l_application_id ='||l_application_id);
2113: END IF;
2114:
2115: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2116:
2117: mo_global.init('AR');
2118: mo_global.set_policy_context('M',l_org_id);
2119:

Line 2904: fnd_message.set_token('APPROVER', fnd_global.user_id);

2900:
2901: l_notes := wf_engine.getitemattrtext(l_item_type, p_dispute_id, 'NOTES');
2902: fnd_message.set_name('AR', 'AR_WF_REJECTED_RESPONSE');
2903: fnd_message.set_token('REQUEST_ID', to_char(p_dispute_id));
2904: fnd_message.set_token('APPROVER', fnd_global.user_id);
2905: l_note_text := fnd_message.GET;
2906:
2907: IF l_notes IS NOT NULL THEN
2908: l_note_text := substrb(l_note_text || ' "' || l_notes || '"', 1, 2000);

Line 3068: AND AcctSites.user_id=FND_GLOBAL.USER_ID()

3064: SELECT /*+ LEADING(RaCmRequests)*/ nvl(sum ( total_amount ), 0) into pending_cmreq_amt
3065: FROM RA_CM_REQUESTS RaCmRequests, AR_PAYMENT_SCHEDULES ArPaymentSchedules, ar_irec_user_acct_sites_all AcctSites, ra_customer_trx ct
3066: WHERE (RaCmRequests.CUSTOMER_TRX_ID = ArPaymentSchedules.CUSTOMER_TRX_ID) AND
3067: nvl(ArPaymentSchedules.terms_sequence_number,1) = 1
3068: AND AcctSites.user_id=FND_GLOBAL.USER_ID()
3069: AND ArPaymentSchedules.customer_id = AcctSites.customer_id
3070: AND AcctSites.customer_site_use_id=ArPaymentSchedules.customer_site_use_id
3071: AND AcctSites.session_id=p_session_id
3072: AND ( ArPaymentSchedules.class = 'INV' OR ArPaymentSchedules.class = 'GUAR' OR ArPaymentSchedules.class = 'CB' OR

Line 3084: AND AcctSites.user_id=FND_GLOBAL.USER_ID()

3080: SELECT /*+ LEADING(RaCmRequests)*/ nvl(sum ( total_amount ), 0) into pending_cmreq_amt
3081: FROM RA_CM_REQUESTS RaCmRequests, AR_PAYMENT_SCHEDULES ArPaymentSchedules, ar_irec_user_acct_sites_all AcctSites, ra_customer_trx ct
3082: WHERE (RaCmRequests.CUSTOMER_TRX_ID = ArPaymentSchedules.CUSTOMER_TRX_ID) AND
3083: nvl(ArPaymentSchedules.terms_sequence_number,1) = 1
3084: AND AcctSites.user_id=FND_GLOBAL.USER_ID()
3085: AND ArPaymentSchedules.customer_id=p_customer_id
3086: AND ArPaymentSchedules.customer_id= AcctSites.customer_id
3087: AND AcctSites.customer_site_use_id=ArPaymentSchedules.customer_site_use_id
3088: AND AcctSites.session_id=p_session_id