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_SITE_USES

Line 568: p_parent_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%type)

564: | |
565: +===========================================================================*/
566: PROCEDURE get_parent_site_use(
567: p_parent_customer_id IN hz_cust_accounts.cust_account_id%type,
568: p_parent_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%type)
569: IS
570: l_parent_site_use_id hz_cust_site_uses.site_use_id%type;
571: BEGIN
572:

Line 570: l_parent_site_use_id hz_cust_site_uses.site_use_id%type;

566: PROCEDURE get_parent_site_use(
567: p_parent_customer_id IN hz_cust_accounts.cust_account_id%type,
568: p_parent_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%type)
569: IS
570: l_parent_site_use_id hz_cust_site_uses.site_use_id%type;
571: BEGIN
572:
573: SELECT
574: decode(count(*),

Line 590: FROM hz_cust_site_uses site_uses,

586: 'N','2')||to_char(site_uses.site_use_id)),
587: 2),
588: null))
589: INTO l_parent_site_use_id
590: FROM hz_cust_site_uses site_uses,
591: hz_cust_acct_sites acct_site
592: WHERE site_uses.site_use_code = 'BILL_TO'
593: and site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
594: and acct_site.cust_account_id = p_parent_customer_id;

Line 640: p_parent_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%type)

636:
637: PROCEDURE get_parent_customer_site(
638: p_bill_to_customer_id IN hz_cust_accounts.cust_account_id%type,
639: p_parent_customer_id OUT NOCOPY hz_cust_accounts.cust_account_id%type,
640: p_parent_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%type)
641: IS
642: l_parent_customer_id hz_cust_accounts.cust_account_id%type;
643: BEGIN
644:

Line 723: hz_cust_site_uses.site_use_id%type,

719: ra_customer_trx.trx_date%type,
720: p_customer_id IN
721: ra_customer_trx.customer_trx_id%type,
722: p_site_use_id IN
723: hz_cust_site_uses.site_use_id%type,
724: p_parent_customer_id IN
725: hz_cust_accounts.cust_account_id%type,
726: p_parent_site_use_id IN
727: hz_cust_site_uses.site_use_id%type,

Line 727: hz_cust_site_uses.site_use_id%type,

723: hz_cust_site_uses.site_use_id%type,
724: p_parent_customer_id IN
725: hz_cust_accounts.cust_account_id%type,
726: p_parent_site_use_id IN
727: hz_cust_site_uses.site_use_id%type,
728: p_currency_code IN
729: fnd_currencies.currency_code%type,
730: p_crtrx_receipt_method_id IN
731: ar_receipt_methods.receipt_method_id%type,

Line 887: hz_cust_site_uses.site_use_id%type,

883: fnd_currencies.currency_code%type,
884: p_bill_to_customer_id IN
885: hz_cust_accounts.cust_account_id%type,
886: p_bill_to_site_use_id IN
887: hz_cust_site_uses.site_use_id%type,
888: p_parent_customer_id IN
889: hz_cust_accounts.cust_account_id%type,
890: p_parent_site_use_id IN
891: hz_cust_site_uses.site_use_id%type,

Line 891: hz_cust_site_uses.site_use_id%type,

887: hz_cust_site_uses.site_use_id%type,
888: p_parent_customer_id IN
889: hz_cust_accounts.cust_account_id%type,
890: p_parent_site_use_id IN
891: hz_cust_site_uses.site_use_id%type,
892: p_crtrx_cust_bank_account_id IN
893: ce_bank_accounts.bank_account_id%type,
894: p_cust_bank_account_id OUT NOCOPY
895: ce_bank_accounts.bank_account_id%type,

Line 1013: hz_cust_site_uses.site_use_id%type,

1009: ra_cust_trx_types.cust_trx_type_id%type,
1010: p_ship_to_customer_id IN
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,

Line 1019: hz_cust_site_uses.site_use_id%type,

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,
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,

Line 1031: hz_cust_site_uses.site_use_id%type,

1027: ce_bank_accounts.bank_account_id%type,
1028: p_paying_customer_id IN
1029: hz_cust_accounts.cust_account_id%type,
1030: p_paying_site_use_id IN
1031: hz_cust_site_uses.site_use_id%type,
1032: p_ship_via IN
1033: ra_customer_trx.ship_via%type,
1034: p_fob_point IN
1035: ra_customer_trx.fob_point%type,

Line 1065: hz_cust_site_uses.site_use_id%type,

1061: --
1062: p_crtrx_ship_to_customer_id IN
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,

Line 1071: hz_cust_site_uses.site_use_id%type,

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,
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,

Line 1130: hz_cust_site_uses.site_use_id%type,

1126: ra_cust_trx_line_gl_dist.gl_date%type,
1127: p_default_ship_to_customer_id OUT NOCOPY
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,

Line 1136: hz_cust_site_uses.site_use_id%type,

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,
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,

Line 1148: hz_cust_site_uses.site_use_id%type,

1144: ce_bank_accounts.bank_account_id%type,
1145: p_default_paying_customer_id OUT NOCOPY
1146: hz_cust_accounts.cust_account_id%type,
1147: p_default_paying_site_use_id OUT NOCOPY
1148: hz_cust_site_uses.site_use_id%type,
1149: p_default_ship_via OUT NOCOPY
1150: ra_customer_trx.ship_via%type,
1151: p_default_ship_date_actual OUT NOCOPY
1152: ra_customer_trx.ship_date_actual%type,

Line 1173: l_bill_to_site_use_id hz_cust_site_uses.site_use_id%type;

1169: l_default_printing_option ar_lookups.meaning%type;
1170: l_default_term_id ra_terms.term_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;

Line 1174: l_ship_to_site_use_id hz_cust_site_uses.site_use_id%type; --4766915

1170: l_default_term_id ra_terms.term_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;

Line 1188: l_paying_site_use_id hz_cust_site_uses.site_use_id%type;

1184: l_error_message varchar2(128);
1185:
1186: l_paying_customer_id hz_cust_accounts.cust_account_id%type;
1187: l_parent_customer_id hz_cust_accounts.cust_account_id%type;
1188: l_paying_site_use_id hz_cust_site_uses.site_use_id%type;
1189: l_parent_site_use_id hz_cust_site_uses.site_use_id%type;
1190:
1191: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
1192: l_payment_method_name ar_receipt_methods.name%type;

Line 1189: l_parent_site_use_id hz_cust_site_uses.site_use_id%type;

1185:
1186: l_paying_customer_id hz_cust_accounts.cust_account_id%type;
1187: l_parent_customer_id hz_cust_accounts.cust_account_id%type;
1188: l_paying_site_use_id hz_cust_site_uses.site_use_id%type;
1189: l_parent_site_use_id hz_cust_site_uses.site_use_id%type;
1190:
1191: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
1192: l_payment_method_name ar_receipt_methods.name%type;
1193: l_creation_method_code ar_receipt_classes.creation_method_code%type;

Line 1532: hz_cust_site_uses site_uses

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)
1536: = site_uses.cust_acct_site_id

Line 1587: hz_cust_site_uses site_uses

1583: /* modified for tca uptake */
1584: SELECT s.salesrep_id
1585: INTO l_primary_salesrep_id
1586: FROM ra_salesreps s,
1587: hz_cust_site_uses site_uses
1588: WHERE s.salesrep_id = site_uses.primary_salesrep_id
1589: AND site_uses.site_use_id = l_bill_to_site_use_id
1590: AND p_trx_date BETWEEN nvl(start_date_active, p_trx_date)
1591: AND nvl(end_date_active, p_trx_date);

Line 1611: hz_cust_site_uses site_uses

1607: /* modified for tca uptake */
1608: SELECT s.salesrep_id
1609: INTO l_primary_salesrep_id
1610: FROM ra_salesreps s,
1611: hz_cust_site_uses site_uses
1612: WHERE s.salesrep_id = site_uses.primary_salesrep_id
1613: AND site_uses.site_use_id = l_ship_to_site_use_id
1614: AND p_trx_date BETWEEN nvl(start_date_active, p_trx_date)
1615: AND nvl(end_date_active, p_trx_date);