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.ARW_SEARCH_CUSTOMERS dependencies on AR_IREC_USER_ACCT_SITES_ALL

Line 800: delete from ar_irec_user_acct_sites_all where (session_id=p_session_id

796:
797: pragma autonomous_transaction ;
798:
799: BEGIN
800: delete from ar_irec_user_acct_sites_all where (session_id=p_session_id
801: or trunc(CREATION_DATE)<=trunc(sysdate-2));
802:
803: l_curr_index := p_custsite_rec_tbl.first;
804:

Line 823: INSERT INTO ar_irec_user_acct_sites_all

819: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id
820: )LOOP
821:
822: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
823: INSERT INTO ar_irec_user_acct_sites_all
824: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
825: VALUES(p_session_id,p_customer_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),p_org_id, trunc(sysdate));
826: END IF;
827: END LOOP;

Line 830: INSERT INTO ar_irec_user_acct_sites_all

826: END IF;
827: END LOOP;
828:
829: ELSIF (( p_site_use_id is not null ) and (p_customer_id is not null)) THEN
830: INSERT INTO ar_irec_user_acct_sites_all
831: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
832: VALUES(p_session_id,p_customer_id,p_site_use_id,p_user_id,trunc(sysdate),p_org_id, trunc(sysdate));
833:
834: END IF;

Line 845: INSERT INTO ar_irec_user_acct_sites_all

841: IF
842: FETCH_SITES_ID_CURSOR_RECORD.address_id IS NOT NULL
843: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0
844: THEN
845: INSERT INTO ar_irec_user_acct_sites_all
846: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
847: VALUES(p_session_id,FETCH_SITES_ID_CURSOR_RECORD.account_id,ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ),p_user_id,trunc(sysdate),p_org_id, trunc(sysdate));
848: END IF;
849: END LOOP;

Line 862: INSERT INTO ar_irec_user_acct_sites_all

858: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=customer_assigned_record.cust_account_id
859: )LOOP
860:
861: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
862: INSERT INTO ar_irec_user_acct_sites_all
863: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
864: VALUES(p_session_id,customer_assigned_record.cust_account_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),p_org_id, trunc(sysdate));
865: END IF;
866: END LOOP;

Line 873: INSERT INTO ar_irec_user_acct_sites_all

869:
870:
871:
872: ELSIF (( p_site_use_id is not null ) and (p_customer_id is not null)) THEN
873: INSERT INTO ar_irec_user_acct_sites_all
874: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
875: VALUES(p_session_id,p_customer_id,p_site_use_id,p_user_id,trunc(sysdate),p_org_id, trunc(sysdate));
876:
877: END IF;

Line 886: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (

882:
883: END LOOP;
884:
885: /* REMOVE DUPLICATE ROWS IF ANY */
886: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (
887: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B
888: WHERE A.org_id = B.org_id
889: AND A.SESSION_ID=B.SESSION_ID
890: AND A.USER_ID=B.USER_ID

Line 887: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B

883: END LOOP;
884:
885: /* REMOVE DUPLICATE ROWS IF ANY */
886: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (
887: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B
888: WHERE A.org_id = B.org_id
889: AND A.SESSION_ID=B.SESSION_ID
890: AND A.USER_ID=B.USER_ID
891: AND A.CUSTOMER_ID=B.CUSTOMER_ID

Line 933: delete from ar_irec_user_acct_sites_all where (session_id=p_session_id

929:
930: pragma autonomous_transaction ;
931:
932: BEGIN
933: delete from ar_irec_user_acct_sites_all where (session_id=p_session_id
934: or trunc(CREATION_DATE)<=trunc(sysdate-2));
935:
936: if(p_org_id is null) then
937: l_org_id := FND_PROFILE.value('ORG_ID');

Line 950: INSERT INTO ar_irec_user_acct_sites_all

946: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id
947: )LOOP
948:
949: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
950: INSERT INTO ar_irec_user_acct_sites_all
951: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
952: VALUES(p_session_id,p_customer_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),l_org_id, trunc(sysdate));
953: END IF;
954: END LOOP;

Line 957: INSERT INTO ar_irec_user_acct_sites_all

953: END IF;
954: END LOOP;
955:
956: ELSIF (( p_site_use_id is not null ) and (p_customer_id is not null)) THEN
957: INSERT INTO ar_irec_user_acct_sites_all
958: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
959: VALUES(p_session_id,p_customer_id,p_site_use_id,p_user_id,trunc(sysdate),l_org_id, trunc(sysdate));
960:
961: END IF;

Line 972: INSERT INTO ar_irec_user_acct_sites_all

968: IF
969: FETCH_SITES_ID_CURSOR_RECORD.address_id IS NOT NULL
970: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0
971: THEN
972: INSERT INTO ar_irec_user_acct_sites_all
973: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
974: VALUES(p_session_id,FETCH_SITES_ID_CURSOR_RECORD.account_id,ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ),p_user_id,trunc(sysdate),l_org_id, trunc(sysdate));
975: END IF;
976: END LOOP;

Line 989: INSERT INTO ar_irec_user_acct_sites_all

985: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=customer_assigned_record.cust_account_id
986: )LOOP
987:
988: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
989: INSERT INTO ar_irec_user_acct_sites_all
990: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
991: VALUES(p_session_id,customer_assigned_record.cust_account_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),l_org_id, trunc(sysdate));
992: END IF;
993: END LOOP;

Line 1000: INSERT INTO ar_irec_user_acct_sites_all

996:
997:
998:
999: ELSIF (( p_site_use_id is not null ) and (p_customer_id is not null)) THEN
1000: INSERT INTO ar_irec_user_acct_sites_all
1001: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
1002: VALUES(p_session_id,p_customer_id,p_site_use_id,p_user_id,trunc(sysdate),l_org_id, trunc(sysdate));
1003:
1004: END IF;

Line 1010: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (

1006: ------------------------------------------------
1007:
1008:
1009: /* REMOVE DUPLICATE ROWS IF ANY */
1010: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (
1011: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B
1012: WHERE A.org_id = B.org_id
1013: AND A.SESSION_ID=B.SESSION_ID
1014: AND A.USER_ID=B.USER_ID

Line 1011: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B

1007:
1008:
1009: /* REMOVE DUPLICATE ROWS IF ANY */
1010: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (
1011: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B
1012: WHERE A.org_id = B.org_id
1013: AND A.SESSION_ID=B.SESSION_ID
1014: AND A.USER_ID=B.USER_ID
1015: AND A.CUSTOMER_ID=B.CUSTOMER_ID

Line 1055: delete from ar_irec_user_acct_sites_all where session_id=p_session_id AND RELATED_CUSTOMER_FLAG = 'Y';

1051:
1052: pragma autonomous_transaction ;
1053:
1054: BEGIN
1055: delete from ar_irec_user_acct_sites_all where session_id=p_session_id AND RELATED_CUSTOMER_FLAG = 'Y';
1056:
1057: select person_party_id into p_party_id from fnd_user where user_id = p_user_id;
1058:
1059: IF (p_is_internal_user='Y') THEN

Line 1064: INSERT INTO ar_irec_user_acct_sites_all

1060: FOR account_assigned_site IN (
1061: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id
1062: )LOOP
1063: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1064: INSERT INTO ar_irec_user_acct_sites_all
1065: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE, RELATED_CUSTOMER_FLAG)
1066: VALUES(p_session_id,p_customer_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),p_org_id, trunc(sysdate), 'Y');
1067: END IF;
1068: END LOOP;

Line 1076: INSERT INTO ar_irec_user_acct_sites_all

1072: FOR FETCH_SITES_ID_CURSOR_RECORD IN FETCH_SITES_ID_CURSOR loop
1073: IF FETCH_SITES_ID_CURSOR_RECORD.address_id IS NOT NULL
1074: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0
1075: THEN
1076: INSERT INTO ar_irec_user_acct_sites_all
1077: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE, RELATED_CUSTOMER_FLAG )
1078: VALUES(p_session_id,FETCH_SITES_ID_CURSOR_RECORD.account_id,ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ),p_user_id,trunc(sysdate),p_org_id, trunc(sysdate), 'Y');
1079: END IF;
1080: END LOOP;

Line 1087: INSERT INTO ar_irec_user_acct_sites_all

1083: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=p_customer_id
1084: )LOOP
1085:
1086: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1087: INSERT INTO ar_irec_user_acct_sites_all
1088: (SESSION_ID,CUSTOMER_ID, CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE, RELATED_CUSTOMER_FLAG)
1089: VALUES(p_session_id,p_customer_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),p_org_id, trunc(sysdate), 'Y');
1090: END IF;
1091: END LOOP;

Line 1097: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (

1093: END IF;
1094:
1095:
1096: /* REMOVE DUPLICATE ROWS IF ANY */
1097: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (
1098: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B
1099: WHERE A.org_id = B.org_id
1100: AND A.SESSION_ID=B.SESSION_ID
1101: AND A.USER_ID=B.USER_ID

Line 1098: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B

1094:
1095:
1096: /* REMOVE DUPLICATE ROWS IF ANY */
1097: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (
1098: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B
1099: WHERE A.org_id = B.org_id
1100: AND A.SESSION_ID=B.SESSION_ID
1101: AND A.USER_ID=B.USER_ID
1102: AND A.CUSTOMER_ID=B.CUSTOMER_ID