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.FUN_OPEN_INTERFACE_PKG dependencies on HZ_PARTIES

Line 51: FROM hz_parties p

47: l_From_Ledger_id_per_le fun_interface_batches.from_ledger_id%type;
48:
49: Cursor c_Init_id_per_name(l_initiator_name IN VARCHAR2) IS
50: SELECT p.party_id
51: FROM hz_parties p
52: WHERE p.party_name = l_initiator_name
53: and p.party_type='ORGANIZATION'
54: and exists (select u.party_usg_assignment_id from hz_party_usg_assignments u
55: where u.party_usage_code = 'INTERCOMPANY_ORG'

Line 64: FROM hz_parties hp, hz_code_assignments hca

60: FROM xle_firstparty_information_v
61: WHERE name=l_from_le_name;
62:
63: /*SELECT hp.party_id
64: FROM hz_parties hp, hz_code_assignments hca
65: WHERE hp.party_name = l_From_Le_name
66: and hca.owner_table_name like 'HZ_PARTIES'
67: and hca.owner_table_id = hp.party_id
68: and hca.class_code like 'LEGAL_ENTITY'

Line 66: and hca.owner_table_name like 'HZ_PARTIES'

62:
63: /*SELECT hp.party_id
64: FROM hz_parties hp, hz_code_assignments hca
65: WHERE hp.party_name = l_From_Le_name
66: and hca.owner_table_name like 'HZ_PARTIES'
67: and hca.owner_table_id = hp.party_id
68: and hca.class_code like 'LEGAL_ENTITY'
69: and hca.class_category like 'LEGAL_FUNCTION';*/
70:

Line 298: FROM hz_parties p

294: l_To_Ledger_id_per_le fun_interface_headers.to_ledger_id%type;
295:
296: Cursor c_reci_id_per_name(l_recipient_name IN VARCHAR2) IS
297: SELECT p.party_id
298: FROM hz_parties p
299: WHERE p.party_name = l_recipient_name
300: and p.party_type='ORGANIZATION'
301: and exists (select u.party_usg_assignment_id from hz_party_usg_assignments u
302: where u.party_usage_code = 'INTERCOMPANY_ORG'

Line 313: FROM hz_parties hp, hz_code_assignments hca

309: WHERE name=l_to_le_name;
310:
311:
312: /*SELECT hp.party_id
313: FROM hz_parties hp, hz_code_assignments hca
314: WHERE hp.party_name = l_to_Le_name
315: and hca.owner_table_name like 'HZ_PARTIES'
316: and hca.owner_table_id = hp.party_id;
317: and hca.class_code like 'LEGAL_ENTITY'

Line 315: and hca.owner_table_name like 'HZ_PARTIES'

311:
312: /*SELECT hp.party_id
313: FROM hz_parties hp, hz_code_assignments hca
314: WHERE hp.party_name = l_to_Le_name
315: and hca.owner_table_name like 'HZ_PARTIES'
316: and hca.owner_table_id = hp.party_id;
317: and hca.class_code like 'LEGAL_ENTITY'
318: and hca.class_category like 'LEGAL_FUNCTION';*/
319:

Line 517: FROM hz_parties hzp,

513: BEGIN
514:
515: SELECT hzp.party_id
516: INTO l_user_id
517: FROM hz_parties hzp,
518: fnd_user u,
519: per_all_people_f pap,
520: (SELECT fnd_global.user_id() AS
521: user_id

Line 592: hz_parties hzp,

588: AND group_id = p_group_id
589: AND batch_id = NVL(p_batch_id,batch_id)
590: AND batch_id IN(SELECT DISTINCT fib.batch_id
591: FROM fun_interface_batches fib,
592: hz_parties hzp,
593: fnd_grants fg,
594: fnd_object_instance_sets fois,
595: hz_relationships hzr,
596: hz_org_contacts hc,

Line 612: AND hzr.subject_table_name = 'HZ_PARTIES'

608: AND fois.instance_set_name = 'FUN_TRX_BATCHES_SET'
609: AND hzr.relationship_code = 'CONTACT_OF'
610: AND hzr.relationship_type = 'CONTACT'
611: AND hzr.directional_flag = 'F'
612: AND hzr.subject_table_name = 'HZ_PARTIES'
613: AND hzr.object_table_name = 'HZ_PARTIES'
614: AND hzr.subject_type = 'PERSON'
615: AND hzr.object_id = hzp.party_id
616: AND fg.grantee_key = l_grantee_key

Line 613: AND hzr.object_table_name = 'HZ_PARTIES'

609: AND hzr.relationship_code = 'CONTACT_OF'
610: AND hzr.relationship_type = 'CONTACT'
611: AND hzr.directional_flag = 'F'
612: AND hzr.subject_table_name = 'HZ_PARTIES'
613: AND hzr.object_table_name = 'HZ_PARTIES'
614: AND hzr.subject_type = 'PERSON'
615: AND hzr.object_id = hzp.party_id
616: AND fg.grantee_key = l_grantee_key
617: AND hzp.party_id = fib.initiator_id --10030555

Line 1240: FROM hz_parties hzp,

1236: --setting the bind variables
1237: -- Bug: 13652693
1238: SELECT hzp.party_id
1239: INTO l_user_id
1240: FROM hz_parties hzp,
1241: fnd_user u,
1242: per_all_people_f pap,
1243: (SELECT fnd_global.user_id() AS
1244: user_id

Line 1318: HZ_PARTIES HZP,

1314: DECODE(FIH.INIT_AMOUNT_CR,NULL,0,FIH.INIT_AMOUNT_CR) INIT_AMOUNT_CR,
1315: DECODE(FIH.INIT_AMOUNT_DR,NULL,0,FIH.INIT_AMOUNT_DR) INIT_AMOUNT_DR
1316: FROM FUN_INTERFACE_BATCHES FIB,
1317: FUN_INTERFACE_HEADERS FIH,
1318: HZ_PARTIES HZP,
1319: FND_GRANTS FG,
1320: FND_OBJECT_INSTANCE_SETS FOIS,
1321: HZ_RELATIONSHIPS HZR,
1322: HZ_ORG_CONTACTS HC,

Line 1344: AND HZR.SUBJECT_TABLE_NAME = ''HZ_PARTIES''

1340: AND FG.GRANTEE_KEY = :GRANTEE_KEY
1341: AND HZR.RELATIONSHIP_CODE = ''CONTACT_OF''
1342: AND HZR.RELATIONSHIP_TYPE = ''CONTACT''
1343: AND HZR.DIRECTIONAL_FLAG = ''F''
1344: AND HZR.SUBJECT_TABLE_NAME = ''HZ_PARTIES''
1345: AND HZR.OBJECT_TABLE_NAME = ''HZ_PARTIES''
1346: AND HZR.SUBJECT_TYPE = ''PERSON''
1347: AND HZR.OBJECT_ID=HZP.PARTY_ID
1348: AND HZP.PARTY_NAME = FIB.INITIATOR_NAME

Line 1345: AND HZR.OBJECT_TABLE_NAME = ''HZ_PARTIES''

1341: AND HZR.RELATIONSHIP_CODE = ''CONTACT_OF''
1342: AND HZR.RELATIONSHIP_TYPE = ''CONTACT''
1343: AND HZR.DIRECTIONAL_FLAG = ''F''
1344: AND HZR.SUBJECT_TABLE_NAME = ''HZ_PARTIES''
1345: AND HZR.OBJECT_TABLE_NAME = ''HZ_PARTIES''
1346: AND HZR.SUBJECT_TYPE = ''PERSON''
1347: AND HZR.OBJECT_ID=HZP.PARTY_ID
1348: AND HZP.PARTY_NAME = FIB.INITIATOR_NAME
1349: AND HC.PARTY_RELATIONSHIP_ID = HZR.RELATIONSHIP_ID

Line 1372: hz_parties hzp,

1368: --selecting teh batches to be purged.
1369: FOR rec4 IN
1370: (SELECT DISTINCT fib.batch_id
1371: FROM fun_interface_batches fib,
1372: hz_parties hzp,
1373: fnd_grants fg,
1374: fnd_object_instance_sets fois,
1375: hz_relationships hzr,
1376: hz_org_contacts hc,

Line 1397: AND hzr.subject_table_name = 'HZ_PARTIES'

1393: AND fg.grantee_key = l_grantee_key
1394: AND hzr.relationship_code = 'CONTACT_OF'
1395: AND hzr.relationship_type = 'CONTACT'
1396: AND hzr.directional_flag = 'F'
1397: AND hzr.subject_table_name = 'HZ_PARTIES'
1398: AND hzr.object_table_name = 'HZ_PARTIES'
1399: AND hzr.subject_type = 'PERSON'
1400: AND hzr.object_id = hzp.party_id
1401: AND hzp.party_name = fib.initiator_name

Line 1398: AND hzr.object_table_name = 'HZ_PARTIES'

1394: AND hzr.relationship_code = 'CONTACT_OF'
1395: AND hzr.relationship_type = 'CONTACT'
1396: AND hzr.directional_flag = 'F'
1397: AND hzr.subject_table_name = 'HZ_PARTIES'
1398: AND hzr.object_table_name = 'HZ_PARTIES'
1399: AND hzr.subject_type = 'PERSON'
1400: AND hzr.object_id = hzp.party_id
1401: AND hzp.party_name = fib.initiator_name
1402: AND hc.party_relationship_id = hzr.relationship_id