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.FV_SF1081_TRANSACTION dependencies on HZ_CUSTOMER_PROFILES

Line 439: FROM HZ_CUSTOMER_PROFILES HCP

435: AND (NVL(HZCA.CUSTOMER_CLASS_CODE,'XXX') LIKE NVL(parm_customer_class , NVL(HZCA.CUSTOMER_CLASS_CODE,'XXX'))
436: OR HZCA.CUST_ACCOUNT_ID LIKE NVL(parm_customer ,'%'))
437: AND RCT.BILL_TO_CUSTOMER_ID IN
438: (SELECT HCP.CUST_ACCOUNT_ID
439: FROM HZ_CUSTOMER_PROFILES HCP
440: WHERE HCP.CUST_ACCOUNT_ID = RCT.BILL_TO_CUSTOMER_ID
441: AND HCP.PROFILE_CLASS_ID = NVL(parm_cust_profile_class_id , HCP.PROFILE_CLASS_ID))
442: AND RCT.CUST_TRX_TYPE_ID IN
443: (SELECT CUST_TRX_TYPE_ID

Line 535: FROM hz_customer_profiles

531: AND rct.customer_trx_id = rtl.customer_trx_id
532: AND rct.set_of_books_id = v_set_of_books_id
533: AND rct.bill_to_customer_id IN
534: (SELECT DISTINCT cust_account_id
535: FROM hz_customer_profiles
536: WHERE profile_class_id =
537: DECODE(parm_cust_profile_class_id,null,profile_class_id,
538: parm_cust_profile_class_id))
539: AND rct.cust_trx_type_id IN