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_PARTIES

Line 29: WHERE cpi.party_source_table = 'HZ_PARTIES'

25:
26: CURSOR pty1_intf_cur IS
27: SELECT ip_interface_id
28: FROM csi_i_party_interface cpi
29: WHERE cpi.party_source_table = 'HZ_PARTIES'
30: AND cpi.inst_interface_id IN (SELECT inst_interface_id
31: FROM csi_instance_interface cii
32: WHERE cii.transaction_identifier IS NOT NULL
33: AND trunc(source_transaction_date)

Line 252: FROM hz_parties

248:
249: FORALL i1 in 1 .. ip_intf_id_upd1.count
250: UPDATE csi_i_party_interface cpi
251: SET cpi.party_id = (SELECT party_id
252: FROM hz_parties
253: WHERE party_name = cpi.party_name
254: AND party_number = NVL(cpi.party_number,party_number))
255: WHERE ip_interface_id=ip_intf_id_upd1(i1)
256: AND cpi.party_id IS NULL

Line 263: FROM hz_parties

259: FORALL i2 in 1 .. ip_intf_id_upd1.count
260: UPDATE csi_i_party_interface cpi
261: SET cpi.contact_party_id =
262: (SELECT party_id
263: FROM hz_parties
264: WHERE party_name = cpi.contact_party_name
265: AND party_number = NVL(cpi.contact_party_number,party_number))
266: WHERE ip_interface_id=ip_intf_id_upd1(i2)
267: AND cpi.contact_party_id IS NULL

Line 314: FROM hz_parties

310: FORALL i2 in 1 .. ip_intf_id_upd2.count
311: UPDATE csi_i_party_interface cpi
312: SET cpi.contact_party_id=
313: (SELECT party_id
314: FROM hz_parties
315: WHERE party_name = cpi.contact_party_name
316: AND party_number = NVL(cpi.contact_party_number,party_number))
317: WHERE ip_interface_id=ip_intf_id_upd2(i2)
318: AND cpi.contact_party_id IS NULL

Line 556: WHERE cpi.party_source_table = 'HZ_PARTIES'

552:
553: CURSOR pty1_intf_cur IS
554: SELECT ip_interface_id
555: FROM csi_i_party_interface cpi
556: WHERE cpi.party_source_table = 'HZ_PARTIES'
557: AND cpi.inst_interface_id IN (SELECT inst_interface_Id
558: FROM csi_instance_interface
559: WHERE transaction_identifier IS NULL
560: AND trunc(source_transaction_date)

Line 779: FROM hz_parties

775:
776: FORALL i1 in 1 .. ip_intf_id_upd1.count
777: UPDATE csi_i_party_interface cpi
778: SET cpi.party_id = (SELECT party_id
779: FROM hz_parties
780: WHERE party_name = cpi.party_name
781: AND party_number = NVL(cpi.party_number,party_number))
782: WHERE ip_interface_id=ip_intf_id_upd1(i1)
783: AND cpi.party_id IS NULL

Line 790: FROM hz_parties

786: FORALL i2 in 1 .. ip_intf_id_upd1.count
787: UPDATE csi_i_party_interface cpi
788: SET cpi.contact_party_id =
789: (SELECT party_id
790: FROM hz_parties
791: WHERE party_name = cpi.contact_party_name
792: AND party_number = NVL(cpi.contact_party_number,party_number))
793: WHERE ip_interface_id=ip_intf_id_upd1(i2)
794: AND cpi.contact_party_id IS NULL

Line 839: FROM hz_parties

835: FORALL i2 in 1 .. ip_intf_id_upd2.count
836: UPDATE csi_i_party_interface cpi
837: SET cpi.contact_party_id=
838: (SELECT party_id
839: FROM hz_parties
840: WHERE party_name = cpi.contact_party_name
841: AND party_number = NVL(cpi.contact_party_number,party_number))
842: WHERE ip_interface_id=ip_intf_id_upd2(i2)
843: AND cpi.contact_party_id IS NULL

Line 1062: WHERE cpi.party_source_table = 'HZ_PARTIES'

1058:
1059: CURSOR pty1_intf_cur IS
1060: SELECT ip_interface_id
1061: FROM csi_i_party_interface cpi
1062: WHERE cpi.party_source_table = 'HZ_PARTIES'
1063: AND cpi.inst_interface_id IN (SELECT inst_interface_id
1064: FROM csi_instance_interface cii
1065: WHERE cii.transaction_identifier = p_txn_identifier)
1066: AND cpi.party_source_table = 'HZ_PARTIES';

Line 1066: AND cpi.party_source_table = 'HZ_PARTIES';

1062: WHERE cpi.party_source_table = 'HZ_PARTIES'
1063: AND cpi.inst_interface_id IN (SELECT inst_interface_id
1064: FROM csi_instance_interface cii
1065: WHERE cii.transaction_identifier = p_txn_identifier)
1066: AND cpi.party_source_table = 'HZ_PARTIES';
1067:
1068: CURSOR pty3_intf_cur IS
1069: SELECT ip_interface_id
1070: FROM csi_i_party_interface cpi

Line 1130: FROM hz_parties

1126:
1127: FORALL i1 in 1 .. ip_intf_id_upd1.count
1128: UPDATE csi_i_party_interface cpi
1129: SET cpi.party_id = (SELECT party_id
1130: FROM hz_parties
1131: WHERE party_name = cpi.party_name
1132: AND party_number = NVL(cpi.party_number,party_number))
1133: WHERE ip_interface_id=ip_intf_id_upd1(i1)
1134: AND cpi.party_id IS NULL

Line 1141: FROM hz_parties

1137: FORALL i2 in 1 .. ip_intf_id_upd1.count
1138: UPDATE csi_i_party_interface cpi
1139: SET cpi.contact_party_id =
1140: (SELECT party_id
1141: FROM hz_parties
1142: WHERE party_name = cpi.contact_party_name
1143: AND party_number = NVL(cpi.contact_party_number,party_number))
1144: WHERE ip_interface_id=ip_intf_id_upd1(i2)
1145: AND cpi.contact_party_id IS NULL