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

Line 370: FROM hz_cust_accounts

366: FORALL i1 in 1 .. ip_intf_id_upd3.count
367: UPDATE csi_i_party_interface cpi
368: SET cpi.party_account1_id=
369: (SELECT cust_account_id
370: FROM hz_cust_accounts
371: WHERE account_number = cpi.party_account1_number
372: AND party_id = cpi.party_id)
373: WHERE ip_interface_id=ip_intf_id_upd3(i1)
374: AND cpi.party_account1_id IS NULL

Line 382: FROM hz_cust_accounts

378: FORALL i2 in 1 .. ip_intf_id_upd3.count
379: UPDATE csi_i_party_interface cpi
380: SET cpi.party_account2_id=
381: (SELECT cust_account_id
382: FROM hz_cust_accounts
383: WHERE account_number = cpi.party_account2_number
384: AND party_id = cpi.party_id)
385: WHERE ip_interface_id=ip_intf_id_upd3(i2)
386: AND cpi.party_account2_id IS NULL

Line 394: FROM hz_cust_accounts

390: FORALL i3 in 1 .. ip_intf_id_upd3.count
391: UPDATE csi_i_party_interface cpi
392: SET cpi.party_account3_id=
393: (SELECT cust_account_id
394: FROM hz_cust_accounts
395: WHERE account_number = cpi.party_account3_number
396: AND party_id = cpi.party_id)
397: WHERE ip_interface_id=ip_intf_id_upd3(i3)
398: AND cpi.party_account3_id IS NULL

Line 896: FROM hz_cust_accounts

892: FORALL i1 in 1 .. ip_intf_id_upd3.count
893: UPDATE csi_i_party_interface cpi
894: SET cpi.party_account1_id=
895: (SELECT cust_account_id
896: FROM hz_cust_accounts
897: WHERE account_number = cpi.party_account1_number
898: AND party_id = cpi.party_id)
899: WHERE ip_interface_id=ip_intf_id_upd3(i1)
900: AND cpi.party_account1_id IS NULL

Line 907: FROM hz_cust_accounts

903: FORALL i2 in 1 .. ip_intf_id_upd3.count
904: UPDATE csi_i_party_interface cpi
905: SET cpi.party_account2_id=
906: (SELECT cust_account_id
907: FROM hz_cust_accounts
908: WHERE account_number = cpi.party_account2_number
909: AND party_id = cpi.party_id)
910: WHERE ip_interface_id=ip_intf_id_upd3(i2)
911: AND cpi.party_account2_id IS NULL

Line 918: FROM hz_cust_accounts

914: FORALL i3 in 1 .. ip_intf_id_upd3.count
915: UPDATE csi_i_party_interface cpi
916: SET cpi.party_account3_id=
917: (SELECT cust_account_id
918: FROM hz_cust_accounts
919: WHERE account_number = cpi.party_account3_number
920: AND party_id = cpi.party_id)
921: WHERE ip_interface_id=ip_intf_id_upd3(i3)
922: AND cpi.party_account3_id IS NULL

Line 1208: FROM hz_cust_accounts

1204: FORALL i1 in 1 .. ip_intf_id_upd3.count
1205: UPDATE csi_i_party_interface cpi
1206: SET cpi.party_account1_id=
1207: (SELECT cust_account_id
1208: FROM hz_cust_accounts
1209: WHERE account_number = cpi.party_account1_number
1210: AND party_id = cpi.party_id)
1211: WHERE ip_interface_id=ip_intf_id_upd3(i1)
1212: AND cpi.party_account1_id IS NULL

Line 1220: FROM hz_cust_accounts

1216: FORALL i2 in 1 .. ip_intf_id_upd3.count
1217: UPDATE csi_i_party_interface cpi
1218: SET cpi.party_account2_id=
1219: (SELECT cust_account_id
1220: FROM hz_cust_accounts
1221: WHERE account_number = cpi.party_account2_number
1222: AND party_id = cpi.party_id)
1223: WHERE ip_interface_id=ip_intf_id_upd3(i2)
1224: AND cpi.party_account2_id IS NULL

Line 1232: FROM hz_cust_accounts

1228: FORALL i3 in 1 .. ip_intf_id_upd3.count
1229: UPDATE csi_i_party_interface cpi
1230: SET cpi.party_account3_id=
1231: (SELECT cust_account_id
1232: FROM hz_cust_accounts
1233: WHERE account_number = cpi.party_account3_number
1234: AND party_id = cpi.party_id)
1235: WHERE ip_interface_id=ip_intf_id_upd3(i3)
1236: AND cpi.party_account3_id IS NULL