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_PROCESS_CREDIT_UTIL dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1015: hz_cust_account_roles.cust_account_role_id%type,

1011: hz_cust_accounts.cust_account_id%type,
1012: p_ship_to_site_use_id IN
1013: hz_cust_site_uses.site_use_id%type,
1014: p_ship_to_contact_id IN
1015: hz_cust_account_roles.cust_account_role_id%type,
1016: p_bill_to_customer_id IN
1017: hz_cust_accounts.cust_account_id%type,
1018: p_bill_to_site_use_id IN
1019: hz_cust_site_uses.site_use_id%type,

Line 1021: hz_cust_account_roles.cust_account_role_id%type,

1017: hz_cust_accounts.cust_account_id%type,
1018: p_bill_to_site_use_id IN
1019: hz_cust_site_uses.site_use_id%type,
1020: p_bill_to_contact_id IN
1021: hz_cust_account_roles.cust_account_role_id%type,
1022: p_primary_salesrep_id IN
1023: ra_salesreps.salesrep_id%type,
1024: p_receipt_method_id IN
1025: ar_receipt_methods.receipt_method_id%type,

Line 1067: hz_cust_account_roles.cust_account_role_id%type,

1063: hz_cust_accounts.cust_account_id%type,
1064: p_crtrx_ship_to_site_use_id IN
1065: hz_cust_site_uses.site_use_id%type,
1066: p_crtrx_ship_to_contact_id IN
1067: hz_cust_account_roles.cust_account_role_id%type,
1068: p_crtrx_bill_to_customer_id IN
1069: hz_cust_accounts.cust_account_id%type,
1070: p_crtrx_bill_to_site_use_id IN
1071: hz_cust_site_uses.site_use_id%type,

Line 1073: hz_cust_account_roles.cust_account_role_id%type,

1069: hz_cust_accounts.cust_account_id%type,
1070: p_crtrx_bill_to_site_use_id IN
1071: hz_cust_site_uses.site_use_id%type,
1072: p_crtrx_bill_to_contact_id IN
1073: hz_cust_account_roles.cust_account_role_id%type,
1074: p_crtrx_primary_salesrep_id IN
1075: ra_salesreps.salesrep_id%type,
1076: p_crtrx_open_rec_flag IN
1077: ra_cust_trx_types.accounting_affect_flag%type,

Line 1132: hz_cust_account_roles.cust_account_role_id%type,

1128: hz_cust_accounts.cust_account_id%type,
1129: p_default_ship_to_site_use_id OUT NOCOPY
1130: hz_cust_site_uses.site_use_id%type,
1131: p_default_ship_to_contact_id OUT NOCOPY
1132: hz_cust_account_roles.cust_account_role_id%type,
1133: p_default_bill_to_customer_id OUT NOCOPY
1134: hz_cust_accounts.cust_account_id%type,
1135: p_default_bill_to_site_use_id OUT NOCOPY
1136: hz_cust_site_uses.site_use_id%type,

Line 1138: hz_cust_account_roles.cust_account_role_id%type,

1134: hz_cust_accounts.cust_account_id%type,
1135: p_default_bill_to_site_use_id OUT NOCOPY
1136: hz_cust_site_uses.site_use_id%type,
1137: p_default_bill_to_contact_id OUT NOCOPY
1138: hz_cust_account_roles.cust_account_role_id%type,
1139: p_default_primary_salesrep_id OUT NOCOPY
1140: ra_salesreps.salesrep_id%type,
1141: p_default_receipt_method_id OUT NOCOPY
1142: ar_receipt_methods.receipt_method_id%type,

Line 1175: l_ship_to_contact_id hz_cust_account_roles.cust_account_role_id%type;

1171: l_default_term_name ra_terms.name%type;
1172: l_bill_to_customer_id hz_cust_accounts.cust_account_id%type;
1173: l_bill_to_site_use_id hz_cust_site_uses.site_use_id%type;
1174: l_ship_to_site_use_id hz_cust_site_uses.site_use_id%type; --4766915
1175: l_ship_to_contact_id hz_cust_account_roles.cust_account_role_id%type;
1176: l_primary_salesrep_id ra_salesreps.salesrep_id%type;
1177: l_number_of_due_dates number;
1178: l_term_due_date date;
1179: l_default_class ra_cust_trx_types.type%type;

Line 1531: FROM hz_cust_account_roles acct_role,

1527: -- Bug 1883538: replaced references of current role state with
1528: -- status column
1529: SELECT distinct acct_role.cust_account_role_id
1530: INTO p_default_bill_to_contact_id
1531: FROM hz_cust_account_roles acct_role,
1532: hz_cust_site_uses site_uses
1533: WHERE site_uses.site_use_id = l_bill_to_site_use_id
1534: AND acct_role.cust_account_id = l_bill_to_customer_id
1535: AND nvl(acct_role.cust_acct_site_id,site_uses.cust_acct_site_id)