DBA Data[Home] [Help]

APPS.FV_SF1081_TRANSACTION dependencies on HZ_CUSTOMER_PROFILES

Line 489: FROM HZ_CUSTOMER_PROFILES HCP

485: FROM hz_cust_accounts hzca
486: WHERE cust_account_id LIKE NVL(parm_customer,'%')))
487: AND RCT.BILL_TO_CUSTOMER_ID IN
488: (SELECT HCP.CUST_ACCOUNT_ID
489: FROM HZ_CUSTOMER_PROFILES HCP
490: WHERE HCP.CUST_ACCOUNT_ID = RCT.BILL_TO_CUSTOMER_ID
491: AND HCP.PROFILE_CLASS_ID = NVL(parm_cust_profile_class_id , HCP.PROFILE_CLASS_ID))
492: AND RCT.CUST_TRX_TYPE_ID IN
493: (SELECT CUST_TRX_TYPE_ID

Line 585: FROM hz_customer_profiles

581: AND rct.customer_trx_id = rtl.customer_trx_id
582: AND rct.set_of_books_id = v_set_of_books_id
583: AND rct.bill_to_customer_id IN
584: (SELECT DISTINCT cust_account_id
585: FROM hz_customer_profiles
586: WHERE profile_class_id =
587: DECODE(parm_cust_profile_class_id,null,profile_class_id,
588: parm_cust_profile_class_id))
589: AND rct.cust_trx_type_id IN