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_TRX_VALIDATE dependencies on HZ_CUST_ACCOUNTS

Line 1111: FROM hz_cust_accounts cust_acct

1107: THEN
1108:
1109: SELECT 'Y'
1110: INTO l_paying_customer_is_valid
1111: FROM hz_cust_accounts cust_acct
1112: WHERE cust_acct.cust_account_id = p_paying_customer_id
1113: AND (
1114: cust_acct.cust_account_id = p_ct_prev_paying_customer_id
1115: OR

Line 1125: FROM hz_cust_accounts cust_acct

1121: ELSE
1122:
1123: SELECT 'Y'
1124: INTO l_paying_customer_is_valid
1125: FROM hz_cust_accounts cust_acct
1126: WHERE cust_acct.cust_account_id = p_paying_customer_id
1127: AND (
1128: cust_acct.cust_account_id = p_ct_prev_paying_customer_id
1129: OR

Line 1153: hz_cust_accounts acc

1149: WHERE cust_acct.cust_account_id =TO_NUMBER(p_bill_to_customer_id)
1150: UNION ALL
1151: SELECT 'X'
1152: FROM ar_paying_relationships_v rel,
1153: hz_cust_accounts acc
1154: WHERE rel.party_id = acc.party_id
1155: AND rel.related_cust_account_id = p_bill_to_customer_id
1156: AND p_ct_prev_trx_date BETWEEN effective_start_date
1157: AND effective_end_date