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 489: from hz_cust_site_uses_all

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

Line 507: from hz_cust_site_uses_all

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

Line 573: from hz_cust_site_uses_all

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

Line 615: from hz_cust_site_uses

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

Line 692: from hz_cust_site_uses

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

Line 734: from hz_cust_site_uses

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

Line 973: p_location IN hz_cust_site_uses.location%TYPE,

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

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

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

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

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

Line 977: RETURN hz_cust_site_uses.site_use_id%type IS

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

Line 979: l_cached_id hz_cust_site_uses.site_use_id%type;

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

Line 980: l_selected_id hz_cust_site_uses.site_use_id%type;

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

Line 992: FROM hz_cust_site_uses site_use,

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

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

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

Line 1021: FROM hz_cust_site_uses site_use,

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

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

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

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

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

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

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

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

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

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

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

Line 1457: l_bill_to_location hz_cust_site_uses.location%type;

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

Line 1458: l_ship_to_location hz_cust_site_uses.location%type;

1454: l_match_site_use_id NUMBER :=NULL;
1455: l_pay_unrelated_invoices_flag
1456: ar_system_parameters.pay_unrelated_invoices_flag%type;
1457: l_bill_to_location hz_cust_site_uses.location%type;
1458: l_ship_to_location hz_cust_site_uses.location%type;
1459: l_dft_bill_to_location hz_cust_site_uses.location%type;
1460: l_dft_ship_to_location hz_cust_site_uses.location%type;
1461: l_dummy NUMBER;
1462: l_default_site_use varchar2(40);

Line 1459: l_dft_bill_to_location hz_cust_site_uses.location%type;

1455: l_pay_unrelated_invoices_flag
1456: ar_system_parameters.pay_unrelated_invoices_flag%type;
1457: l_bill_to_location hz_cust_site_uses.location%type;
1458: l_ship_to_location hz_cust_site_uses.location%type;
1459: l_dft_bill_to_location hz_cust_site_uses.location%type;
1460: l_dft_ship_to_location hz_cust_site_uses.location%type;
1461: l_dummy NUMBER;
1462: l_default_site_use varchar2(40);
1463:

Line 1460: l_dft_ship_to_location hz_cust_site_uses.location%type;

1456: ar_system_parameters.pay_unrelated_invoices_flag%type;
1457: l_bill_to_location hz_cust_site_uses.location%type;
1458: l_ship_to_location hz_cust_site_uses.location%type;
1459: l_dft_bill_to_location hz_cust_site_uses.location%type;
1460: l_dft_ship_to_location hz_cust_site_uses.location%type;
1461: l_dummy NUMBER;
1462: l_default_site_use varchar2(40);
1463:
1464: BEGIN

Line 1955: hz_cust_site_uses su,

1951: into l_dft_bill_to_location
1952: from hz_cust_acct_sites acct_site,
1953: hz_party_sites party_site,
1954: hz_locations loc,
1955: hz_cust_site_uses su,
1956: fnd_territories_vl t
1957: where acct_site.cust_acct_site_id = su.cust_acct_site_id
1958: and acct_site.party_site_id = party_site.party_site_id
1959: and loc.location_id = party_site.location_id

Line 1996: hz_cust_site_uses su,

1992: into l_dft_ship_to_location
1993: from hz_cust_acct_sites acct_site,
1994: hz_party_sites party_site,
1995: hz_locations loc,
1996: hz_cust_site_uses su,
1997: fnd_territories_vl t
1998: where acct_site.cust_acct_site_id = su.cust_acct_site_id
1999: and acct_site.party_site_id = party_site.party_site_id
2000: and loc.location_id = party_site.location_id

Line 2606: hz_cust_site_uses su,

2602: into x_paying_customer_site_use_id
2603: from hz_cust_acct_sites acct_site,
2604: hz_party_sites party_site,
2605: hz_locations loc,
2606: hz_cust_site_uses su,
2607: fnd_territories_vl t
2608: where acct_site.cust_acct_site_id = su.cust_acct_site_id
2609: and acct_site.party_site_id = party_site.party_site_id
2610: and loc.location_id = party_site.location_id