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.OKS_IB_UTIL_PVT dependencies on HZ_CUST_ACCOUNTS

Line 861: From HZ_CUST_ACCOUNTS CA

857: And tmp.Parent_id = p_batch_Id;
858:
859: Cursor l_party_csr Is
860: Select party_id
861: From HZ_CUST_ACCOUNTS CA
862: Where CA.Cust_account_id = p_new_account_Id;
863: i Number;
864: l_org_id number;
865: l_party_id number;

Line 974: From HZ_CUST_ACCOUNTS CA1

970: SELECT CA1.Account_number AccountNumber
971: , CA1.CUST_ACCOUNT_ID AccountId,
972: Party.party_name PartyName
973: , Party.party_id PartyId
974: From HZ_CUST_ACCOUNTS CA1
975: , HZ_PARTIES party
976: WHERE CA1.party_id = P_party_id
977: And CA1. cust_account_id = p_account_id
978: And CA1.party_id = party.party_id

Line 987: FROM HZ_CUST_ACCOUNTS CA2

983: SELECT CA2.Account_number AccountNumber
984: , CA2.cust_account_id AccountId
985: , Party1.party_name PartyName
986: , Party1.party_id PartyId
987: FROM HZ_CUST_ACCOUNTS CA2
988: , HZ_PARTIES party1
989: , HZ_CUST_ACCT_RELATE_ALL A
990: , HZ_CUST_ACCOUNTS B
991: WHERE CA2.party_id = party1.party_id

Line 990: , HZ_CUST_ACCOUNTS B

986: , Party1.party_id PartyId
987: FROM HZ_CUST_ACCOUNTS CA2
988: , HZ_PARTIES party1
989: , HZ_CUST_ACCT_RELATE_ALL A
990: , HZ_CUST_ACCOUNTS B
991: WHERE CA2.party_id = party1.party_id
992: And CA2.cust_account_id = A.RELATED_CUST_ACCOUNT_ID
993: And B.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID
994: And Ca2.cust_account_id = p_account_id

Line 1004: From HZ_CUST_ACCOUNTS CA

1000:
1001:
1002: Cursor l_party_csr Is
1003: Select party_id
1004: From HZ_CUST_ACCOUNTS CA
1005: Where CA.Cust_account_id = p_new_account_Id;
1006:
1007:
1008: