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

Line 153: from hz_cust_site_uses

149: ) then
150: --
151: select status
152: into l_status
153: from hz_cust_site_uses
154: where site_use_id = p_site_use_id;
155:
156: --
157: if ( l_status = 'A' ) then

Line 225: from hz_cust_site_uses su

221: -- first we encounter.
222: --
223: cursor c_site_use is select su.site_use_id,
224: su.status
225: from hz_cust_site_uses su
226: where su.cust_acct_site_id = p_address_id
227: and su.site_use_code = p_site_use_code
228: order
229: by su.status;

Line 242: -- This procedure updates the staus of a row in hz_cust_site_uses

238: -- PROCEDURE
239: -- update_su_status
240: --
241: -- DESCRIPTION
242: -- This procedure updates the staus of a row in hz_cust_site_uses
243: --
244: -- SCOPE - PUBLIC
245: --
246: -- EXETERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 271: update hz_cust_site_uses su

267: --
268: begin
269: --
270: --
271: update hz_cust_site_uses su
272: set su.status = p_status
273: where su.site_use_id = p_site_use_id;
274: --
275: --

Line 343: from hz_cust_site_uses su,

339: --
340: --
341: select count(1)
342: into dummy
343: from hz_cust_site_uses su,
344: hz_cust_acct_sites a
345: where su.cust_acct_site_ID = a.cust_acct_site_ID
346: and a.cust_account_id = p_customer_id
347: and su.site_use_code = p_site_use_code

Line 370: from hz_cust_site_uses

366: -- An address can only have one active site use of each type.
367: --
368: select count(1)
369: into dummy
370: from hz_cust_site_uses
371: where site_use_code = p_site_use_code
372: and cust_acct_site_ID = p_address_id
373: and status = 'A'
374: and ( ( p_site_use_id is null ) or site_use_id <> p_site_use_id);

Line 431: from hz_cust_site_uses su,

427: --
428: --
429: select count(1)
430: into dummy
431: from hz_cust_site_uses su,
432: hz_cust_acct_sites a
433: where su.cust_acct_site_ID = a.cust_acct_site_ID
434: and a.cust_account_id = p_customer_id
435: and su.site_use_code = p_site_use_code

Line 465: from hz_cust_site_uses

461: -- An address can only have one active site use of each type.
462: --
463: select count(1)
464: into dummy
465: from hz_cust_site_uses
466: where site_use_code = p_site_use_code
467: and cust_acct_site_ID = p_address_id
468: and status = 'A'
469: and ( ( p_site_use_id is null ) or site_use_id <> p_site_use_id);

Line 496: -- in hz_cust_site_uses have unique locations within

492: -- check_unique_location
493: --
494: -- DESCRIPTION
495: -- This procedure ensures validates to ensure rows
496: -- in hz_cust_site_uses have unique locations within
497: -- customer/site_use_code
498: --
499: -- SCOPE - PUBLIC
500: --

Line 534: from hz_cust_site_uses su,

530: BEGIN
531:
532: select 1
533: into dummy
534: from hz_cust_site_uses su,
535: hz_cust_acct_sites addr
536: where su.cust_acct_site_ID = addr.cust_acct_site_ID
537: and su.site_use_code = p_site_use_code
538: and su.location = p_location

Line 564: -- in hz_cust_site_uses have unique locations within

560: -- check_unique_location
561: --
562: -- DESCRIPTION
563: -- This procedure ensures validates to ensure rows
564: -- in hz_cust_site_uses have unique locations within
565: -- customer/site_use_code
566: --
567: -- SCOPE - PUBLIC
568: --

Line 606: from hz_cust_site_uses su,

602: BEGIN
603:
604: select 1
605: into dummy
606: from hz_cust_site_uses su,
607: hz_cust_acct_sites addr
608: where su.cust_acct_site_ID = addr.cust_acct_site_ID
609: and su.site_use_code = p_site_use_code
610: and su.location = p_location

Line 613: and su.org_id = (select org_id from hz_cust_site_uses where site_use_id=p_site_use_id) -- 6066859

609: and su.site_use_code = p_site_use_code
610: and su.location = p_location
611: and addr.cust_account_ID = p_customer_id
612: and ( ( p_site_use_id is null ) or ( site_use_id <> p_site_use_id ))
613: and su.org_id = (select org_id from hz_cust_site_uses where site_use_id=p_site_use_id) -- 6066859
614: and su.STATUS = 'A'
615: and rownum = 1;
616: --
617: IF ( dummy >= 1 ) THEN

Line 672: hz_cust_site_uses su

668: select count(1)
669: into dummy
670: from hz_cust_accounts cust,
671: hz_cust_acct_sites addr,
672: hz_cust_site_uses su
673: where su.cust_acct_site_ID = addr.cust_acct_site_ID
674: and addr.cust_account_ID = cust.cust_account_ID
675: and cust.cust_account_ID = p_customer_id
676: and site_use_code = p_site_use_code

Line 826: select hz_cust_site_uses_s.nextval into x_site_use_id from dual;

822:
823: x_return_status := FND_API.G_RET_STS_SUCCESS;
824:
825:
826: select hz_cust_site_uses_s.nextval into x_site_use_id from dual;
827: --
828: --
829: --
830: -- Location will be null if automatic site number = 'Y'

Line 1169: FROM hz_cust_site_uses

1165: CURSOR cu_version IS
1166: SELECT ROWID,
1167: OBJECT_VERSION_NUMBER,
1168: LAST_UPDATE_DATE
1169: FROM hz_cust_site_uses
1170: WHERE site_use_id = X_Site_Use_Id;
1171:
1172: l_site_object_version_number NUMBER;
1173: l_site_use_rowid ROWID;

Line 1190: FND_MESSAGE.SET_TOKEN('RECORD','hz_cust_site_uses');

1186: l_site_object_version_number,
1187: l_site_use_last_update_date ;
1188: IF cu_version%NOTFOUND THEN
1189: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
1190: FND_MESSAGE.SET_TOKEN('RECORD','hz_cust_site_uses');
1191: FND_MESSAGE.SET_TOKEN('ID',x_site_use_id);
1192: FND_MSG_PUB.ADD;
1193: x_return_status := FND_API.G_RET_STS_ERROR;
1194: END IF;

Line 1201: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_cust_site_uses');

1197: IF TO_CHAR(X_Last_Update_Date,'DD-MON-YYYY HH:MI:SS') <>
1198: TO_CHAR(l_site_use_last_update_date,'DD-MON-YYYY HH:MI:SS')
1199: THEN
1200: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1201: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_cust_site_uses');
1202: FND_MSG_PUB.ADD;
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: END IF;
1205: ELSE

Line 1411: from hz_cust_site_uses

1407: -- Backward compatibility
1408: --
1409: SELECT last_update_date
1410: into x_last_update_date
1411: from hz_cust_site_uses
1412: where site_use_id = x_site_use_id;
1413: --
1414: --
1415: --