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.AR_DEPOSIT_LIB_PVT dependencies on HZ_CUST_SITE_USES

Line 104: hz_cust_site_uses site_uses

100: hz_relationships rel,
101: hz_org_contacts org_cont,
102: hz_parties rel_party,
103: hz_cust_acct_sites acct_site,
104: hz_cust_site_uses site_uses
105: where acct_role.party_id = rel.party_id
106: and acct_role.role_type = 'CONTACT'
107: and org_cont.party_relationship_id = rel.relationship_id
108: and rel.subject_id = party.party_id

Line 276: hz_cust_site_uses su,

272: into l_default_srep_id_1
273: from hz_cust_acct_sites acct_site,
274: hz_party_sites party_site,
275: hz_locations loc,
276: hz_cust_site_uses su,
277: fnd_territories_vl t
278: where acct_site.cust_acct_site_id = su.cust_acct_site_id
279: and acct_site.party_site_id = party_site.party_site_id
280: and loc.location_id = party_site.location_id

Line 324: HZ_CUST_SITE_USES SU

320: SU.SITE_USE_ID SITE_USE_ID ,
321: SU.PRIMARY_SALESREP_ID
322: FROM
323: HZ_CUST_ACCT_SITES A,
324: HZ_CUST_SITE_USES SU
325: WHERE
326: A.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
327: AND SU.SITE_USE_CODE = 'SHIP_TO'
328: ) asa

Line 487: from hz_cust_site_uses_all

483: 'BILL_TO',NULL,p_return_status);
484: begin
485: select territory_id
486: into l_territory_id
487: from hz_cust_site_uses_all
488: where site_use_id = l_Site_Use_Id ;
489:
490: exception
491: when no_data_found then

Line 505: from hz_cust_site_uses_all

501: 'SHIP_TO',NULL,p_return_status);
502: begin
503: select territory_id
504: into l_territory_id
505: from hz_cust_site_uses_all
506: where site_use_id =l_Site_Use_Id ;
507:
508: exception
509: when no_data_found then

Line 571: from hz_cust_site_uses_all

567: 'SHIP_TO',NULL, p_return_status);
568: begin
569: select ship_via
570: into l_ship_via_ship_site_default
571: from hz_cust_site_uses_all
572: where site_use_id =l_Site_Use_Id ;
573:
574: exception
575: when no_data_found then

Line 613: from hz_cust_site_uses

609: 'BILL_TO',NULL,p_return_status);
610: begin
611: select ship_via
612: into l_ship_via_bill_site_default
613: from hz_cust_site_uses
614: where site_use_id = l_Site_Use_Id;
615:
616: exception
617: when no_data_found then

Line 690: from hz_cust_site_uses

686: 'SHIP_TO',NULL,p_return_status);
687: begin
688: select fob_point
689: into l_fob_ship_site_default
690: from hz_cust_site_uses
691: where site_use_id =l_Site_Use_Id ;
692:
693: exception
694: when no_data_found then

Line 732: from hz_cust_site_uses

728: 'SHIP_TO',NULL,p_return_status);
729: begin
730: select fob_point
731: into l_fob_bill_site_default
732: from hz_cust_site_uses
733: where site_use_id = l_Site_Use_Id;
734:
735: exception
736: when no_data_found then

Line 971: p_location IN hz_cust_site_uses.location%TYPE,

967: +=======================================================================*/
968:
969: FUNCTION Get_Site_Use_Id(
970: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
971: p_location IN hz_cust_site_uses.location%TYPE,
972: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
973: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
974: p_return_status OUT NOCOPY VARCHAR2)
975: RETURN hz_cust_site_uses.site_use_id%type IS

Line 972: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,

968:
969: FUNCTION Get_Site_Use_Id(
970: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
971: p_location IN hz_cust_site_uses.location%TYPE,
972: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
973: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
974: p_return_status OUT NOCOPY VARCHAR2)
975: RETURN hz_cust_site_uses.site_use_id%type IS
976:

Line 973: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,

969: FUNCTION Get_Site_Use_Id(
970: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
971: p_location IN hz_cust_site_uses.location%TYPE,
972: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
973: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
974: p_return_status OUT NOCOPY VARCHAR2)
975: RETURN hz_cust_site_uses.site_use_id%type IS
976:
977: l_cached_id hz_cust_site_uses.site_use_id%type;

Line 975: RETURN hz_cust_site_uses.site_use_id%type IS

971: p_location IN hz_cust_site_uses.location%TYPE,
972: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
973: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
974: p_return_status OUT NOCOPY VARCHAR2)
975: RETURN hz_cust_site_uses.site_use_id%type IS
976:
977: l_cached_id hz_cust_site_uses.site_use_id%type;
978: l_selected_id hz_cust_site_uses.site_use_id%type;
979: l_index BINARY_INTEGER;

Line 977: l_cached_id hz_cust_site_uses.site_use_id%type;

973: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
974: p_return_status OUT NOCOPY VARCHAR2)
975: RETURN hz_cust_site_uses.site_use_id%type IS
976:
977: l_cached_id hz_cust_site_uses.site_use_id%type;
978: l_selected_id hz_cust_site_uses.site_use_id%type;
979: l_index BINARY_INTEGER;
980: BEGIN
981:

Line 978: l_selected_id hz_cust_site_uses.site_use_id%type;

974: p_return_status OUT NOCOPY VARCHAR2)
975: RETURN hz_cust_site_uses.site_use_id%type IS
976:
977: l_cached_id hz_cust_site_uses.site_use_id%type;
978: l_selected_id hz_cust_site_uses.site_use_id%type;
979: l_index BINARY_INTEGER;
980: BEGIN
981:
982: arp_util.debug('ar_deposit_lib_pvt.Get_Site_Use_Id() +' );

Line 990: FROM hz_cust_site_uses site_use,

986: BEGIN
987:
988: SELECT site_use.site_use_id
989: INTO l_selected_id
990: FROM hz_cust_site_uses site_use,
991: hz_cust_acct_sites acct_site
992: WHERE acct_site.cust_account_id = p_customer_id
993: AND acct_site.status = 'A'
994: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id

Line 1003: arp_util.debug('No data found in the hz_cust_site_uses

999: AND site_use.status = 'A'
1000: AND site_use.location = p_location;
1001: EXCEPTION
1002: WHEN no_data_found THEN
1003: arp_util.debug('No data found in the hz_cust_site_uses
1004: for the location :'||p_location);
1005: p_return_status := FND_API.G_RET_STS_ERROR;
1006: FND_MESSAGE.SET_NAME('AR','AR_DAPI_CUS_LOC_INVALID');
1007: FND_MSG_PUB.Add;

Line 1019: FROM hz_cust_site_uses site_use,

1015: BEGIN
1016:
1017: SELECT site_use.site_use_id
1018: INTO l_selected_id
1019: FROM hz_cust_site_uses site_use,
1020: hz_cust_acct_sites acct_site
1021: WHERE acct_site.cust_account_id = p_customer_id
1022: AND acct_site.status = 'A'
1023: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id

Line 1390: x_bill_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,

1386: p_batch_source_name IN ra_batch_sources.name%type,
1387: x_cust_trx_type_id IN OUT NOCOPY NUMBER,
1388: p_cust_trx_type IN varchar2,
1389: x_bill_to_customer_id IN OUT NOCOPY NUMBER,
1390: x_bill_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1391: p_bill_to_customer_name IN hz_parties.party_name%TYPE,
1392: p_bill_to_customer_number IN
1393: hz_cust_accounts.account_number%TYPE,
1394: p_bill_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,

Line 1394: p_bill_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,

1390: x_bill_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1391: p_bill_to_customer_name IN hz_parties.party_name%TYPE,
1392: p_bill_to_customer_number IN
1393: hz_cust_accounts.account_number%TYPE,
1394: p_bill_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,
1395: x_bill_to_contact_id IN OUT NOCOPY NUMBER,
1396: p_bill_to_contact_first_name IN VARCHAR2,
1397: p_bill_to_contact_last_name IN VARCHAR2,
1398: x_ship_to_customer_id IN OUT NOCOPY NUMBER,

Line 1399: x_ship_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,

1395: x_bill_to_contact_id IN OUT NOCOPY NUMBER,
1396: p_bill_to_contact_first_name IN VARCHAR2,
1397: p_bill_to_contact_last_name IN VARCHAR2,
1398: x_ship_to_customer_id IN OUT NOCOPY NUMBER,
1399: x_ship_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1400: p_ship_to_customer_name IN hz_parties.party_name%TYPE,
1401: p_ship_to_customer_number IN
1402: hz_cust_accounts.account_number%TYPE,
1403: p_ship_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,

Line 1403: p_ship_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,

1399: x_ship_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1400: p_ship_to_customer_name IN hz_parties.party_name%TYPE,
1401: p_ship_to_customer_number IN
1402: hz_cust_accounts.account_number%TYPE,
1403: p_ship_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,
1404: x_ship_to_contact_id IN OUT NOCOPY NUMBER,
1405: p_ship_to_contact_first_name IN VARCHAR2,
1406: p_ship_to_contact_last_name IN VARCHAR2,
1407: p_usr_currency_code IN fnd_currencies_vl.name%TYPE,

Line 1419: x_paying_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,

1415: x_sold_to_customer_id IN OUT NOCOPY NUMBER,
1416: p_sold_to_customer_name IN VARCHAR2,
1417: p_sold_to_customer_number IN VARCHAR2,
1418: x_paying_customer_id IN OUT NOCOPY NUMBER ,
1419: x_paying_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1420: p_paying_customer_name IN VARCHAR2,
1421: p_paying_customer_number IN VARCHAR2,
1422: p_paying_location IN VARCHAR2,
1423: x_receipt_method_id IN OUT NOCOPY NUMBER ,

Line 1455: l_bill_to_location hz_cust_site_uses.location%type;

1451: l_match_address_id NUMBER :=NULL;
1452: l_match_site_use_id NUMBER :=NULL;
1453: l_pay_unrelated_invoices_flag
1454: ar_system_parameters.pay_unrelated_invoices_flag%type;
1455: l_bill_to_location hz_cust_site_uses.location%type;
1456: l_ship_to_location hz_cust_site_uses.location%type;
1457: l_dft_bill_to_location hz_cust_site_uses.location%type;
1458: l_dft_ship_to_location hz_cust_site_uses.location%type;
1459: l_dummy NUMBER;

Line 1456: l_ship_to_location hz_cust_site_uses.location%type;

1452: l_match_site_use_id NUMBER :=NULL;
1453: l_pay_unrelated_invoices_flag
1454: ar_system_parameters.pay_unrelated_invoices_flag%type;
1455: l_bill_to_location hz_cust_site_uses.location%type;
1456: l_ship_to_location hz_cust_site_uses.location%type;
1457: l_dft_bill_to_location hz_cust_site_uses.location%type;
1458: l_dft_ship_to_location hz_cust_site_uses.location%type;
1459: l_dummy NUMBER;
1460:

Line 1457: l_dft_bill_to_location hz_cust_site_uses.location%type;

1453: l_pay_unrelated_invoices_flag
1454: ar_system_parameters.pay_unrelated_invoices_flag%type;
1455: l_bill_to_location hz_cust_site_uses.location%type;
1456: l_ship_to_location hz_cust_site_uses.location%type;
1457: l_dft_bill_to_location hz_cust_site_uses.location%type;
1458: l_dft_ship_to_location hz_cust_site_uses.location%type;
1459: l_dummy NUMBER;
1460:
1461:

Line 1458: l_dft_ship_to_location hz_cust_site_uses.location%type;

1454: ar_system_parameters.pay_unrelated_invoices_flag%type;
1455: l_bill_to_location hz_cust_site_uses.location%type;
1456: l_ship_to_location hz_cust_site_uses.location%type;
1457: l_dft_bill_to_location hz_cust_site_uses.location%type;
1458: l_dft_ship_to_location hz_cust_site_uses.location%type;
1459: l_dummy NUMBER;
1460:
1461:
1462: BEGIN

Line 1949: hz_cust_site_uses su,

1945: into l_dft_bill_to_location
1946: from hz_cust_acct_sites acct_site,
1947: hz_party_sites party_site,
1948: hz_locations loc,
1949: hz_cust_site_uses su,
1950: fnd_territories_vl t
1951: where acct_site.cust_acct_site_id = su.cust_acct_site_id
1952: and acct_site.party_site_id = party_site.party_site_id
1953: and loc.location_id = party_site.location_id

Line 1983: hz_cust_site_uses su,

1979: into l_dft_ship_to_location
1980: from hz_cust_acct_sites acct_site,
1981: hz_party_sites party_site,
1982: hz_locations loc,
1983: hz_cust_site_uses su,
1984: fnd_territories_vl t
1985: where acct_site.cust_acct_site_id = su.cust_acct_site_id
1986: and acct_site.party_site_id = party_site.party_site_id
1987: and loc.location_id = party_site.location_id

Line 2580: hz_cust_site_uses su,

2576: into x_paying_customer_site_use_id
2577: from hz_cust_acct_sites acct_site,
2578: hz_party_sites party_site,
2579: hz_locations loc,
2580: hz_cust_site_uses su,
2581: fnd_territories_vl t
2582: where acct_site.cust_acct_site_id = su.cust_acct_site_id
2583: and acct_site.party_site_id = party_site.party_site_id
2584: and loc.location_id = party_site.location_id