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_REPORT_PVT dependencies on HZ_PARTIES

Line 25: l_person_id HZ_PARTIES.party_id%TYPE;

21: ) IS
22: l_api_name VARCHAR2(30);
23: l_progress VARCHAR2(3);
24:
25: l_person_id HZ_PARTIES.party_id%TYPE;
26: l_grantee_key FND_GRANTS.grantee_key%TYPE;
27: BEGIN
28: l_api_name := 'build_summary_outquery';
29: l_progress := '000';

Line 43: FROM HZ_PARTIES HZP,

39: l_progress := '010';
40: BEGIN
41: SELECT distinct(HZP.party_id)
42: INTO l_person_id
43: FROM HZ_PARTIES HZP,
44: FND_USER U,
45: PER_ALL_PEOPLE_F PAP,
46: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR
47: WHERE CURR.user_id = U.user_id

Line 137: HZ_PARTIES INIT_P,

133: FROM FUN_TRX_BATCHES FTB,
134: FUN_TRX_HEADERS FTH,
135: XLE_ENTITY_PROFILES XLE,
136: FND_LOOKUP_VALUES LKUP,
137: HZ_PARTIES INIT_P,
138: FUN_TRX_TYPES_VL FTTVL,
139: FND_CURRENCIES_VL FCV,
140: GL_LEDGERS GL,
141: FUN_TRX_BATCHES FTB_ORIG,

Line 146: HZ_PARTIES RECI_P,

142: FUN_TRX_BATCHES FTB_REV,
143: GL_LEDGERS GL1,
144: FUN_TRX_HEADERS FTH_ORIG,
145: FUN_TRX_HEADERS FTH_REV,
146: HZ_PARTIES RECI_P,
147: XLE_ENTITY_PROFILES XLE1,
148: FND_LOOKUP_VALUES LKUP1,
149: FND_GRANTS FG,
150: FND_OBJECT_INSTANCE_SETS FOIS,

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

185: AND HZC.PARTY_RELATIONSHIP_ID = HZR.RELATIONSHIP_ID
186: AND HZCR.ORG_CONTACT_ID = HZC.ORG_CONTACT_ID
187: AND HZCR.ROLE_TYPE = ''INTERCOMPANY_CONTACT_FOR''
188: AND HZR.DIRECTIONAL_FLAG = ''F''
189: AND HZR.SUBJECT_TABLE_NAME = ''HZ_PARTIES''
190: AND HZR.OBJECT_TABLE_NAME = ''HZ_PARTIES''
191: AND HZR.SUBJECT_TYPE = ''PERSON''
192: AND HZR.OBJECT_ID = INIT_P.PARTY_ID
193: AND HZR.STATUS = ''A''

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

186: AND HZCR.ORG_CONTACT_ID = HZC.ORG_CONTACT_ID
187: AND HZCR.ROLE_TYPE = ''INTERCOMPANY_CONTACT_FOR''
188: AND HZR.DIRECTIONAL_FLAG = ''F''
189: AND HZR.SUBJECT_TABLE_NAME = ''HZ_PARTIES''
190: AND HZR.OBJECT_TABLE_NAME = ''HZ_PARTIES''
191: AND HZR.SUBJECT_TYPE = ''PERSON''
192: AND HZR.OBJECT_ID = INIT_P.PARTY_ID
193: AND HZR.STATUS = ''A''
194: AND HZR.SUBJECT_ID= ' || l_person_id;

Line 296: l_person_id HZ_PARTIES.party_id%TYPE;

292:
293: l_acc_segment fnd_id_flex_segments.application_column_name%TYPE;
294:
295:
296: l_person_id HZ_PARTIES.party_id%TYPE;
297: l_grantee_key FND_GRANTS.grantee_key%TYPE;
298: BEGIN
299: l_api_name := 'build_account_outquery';
300: l_progress := '000';

Line 314: FROM HZ_PARTIES HZP,

310: l_progress := '010';
311: BEGIN
312: SELECT distinct(HZP.party_id)
313: INTO l_person_id
314: FROM HZ_PARTIES HZP,
315: FND_USER U,
316: PER_ALL_PEOPLE_F PAP,
317: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR
318: WHERE CURR.user_id = U.user_id

Line 454: HZ_PARTIES INIT_P,

450: fnd_lookup_values lkup2,
451: FUN_TRX_BATCHES FTB,
452: FUN_TRX_BATCHES FTB_REV,
453: FUN_TRX_BATCHES FTB_ORIG,
454: HZ_PARTIES INIT_P,
455: HZ_PARTIES RECI_P,
456: FUN_TRX_HEADERS FTH,
457: FUN_TRX_HEADERS FTH_REV,
458: FUN_TRX_HEADERS FTH_ORIG,

Line 455: HZ_PARTIES RECI_P,

451: FUN_TRX_BATCHES FTB,
452: FUN_TRX_BATCHES FTB_REV,
453: FUN_TRX_BATCHES FTB_ORIG,
454: HZ_PARTIES INIT_P,
455: HZ_PARTIES RECI_P,
456: FUN_TRX_HEADERS FTH,
457: FUN_TRX_HEADERS FTH_REV,
458: FUN_TRX_HEADERS FTH_ORIG,
459: FUN_TRX_TYPES_VL FTTVL,

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

515: AND HZC.PARTY_RELATIONSHIP_ID = HZR.RELATIONSHIP_ID
516: AND HZCR.ORG_CONTACT_ID = HZC.ORG_CONTACT_ID
517: AND HZCR.ROLE_TYPE = ''INTERCOMPANY_CONTACT_FOR''
518: AND HZR.DIRECTIONAL_FLAG = ''F''
519: AND HZR.SUBJECT_TABLE_NAME = ''HZ_PARTIES''
520: AND HZR.OBJECT_TABLE_NAME = ''HZ_PARTIES''
521: AND HZR.SUBJECT_TYPE = ''PERSON''
522: AND HZR.direction_code=''P''
523: AND HZR.OBJECT_ID = INIT_P.PARTY_ID

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

516: AND HZCR.ORG_CONTACT_ID = HZC.ORG_CONTACT_ID
517: AND HZCR.ROLE_TYPE = ''INTERCOMPANY_CONTACT_FOR''
518: AND HZR.DIRECTIONAL_FLAG = ''F''
519: AND HZR.SUBJECT_TABLE_NAME = ''HZ_PARTIES''
520: AND HZR.OBJECT_TABLE_NAME = ''HZ_PARTIES''
521: AND HZR.SUBJECT_TYPE = ''PERSON''
522: AND HZR.direction_code=''P''
523: AND HZR.OBJECT_ID = INIT_P.PARTY_ID
524: AND HZR.STATUS = ''A''

Line 688: l_person_id HZ_PARTIES.party_id%TYPE;

684: ) IS
685: l_api_name VARCHAR2(30);
686: l_progress VARCHAR2(3);
687:
688: l_person_id HZ_PARTIES.party_id%TYPE;
689: l_grantee_key FND_GRANTS.grantee_key%TYPE;
690: BEGIN
691: l_api_name := 'build_summary_inquery';
692: l_progress := '000';

Line 706: FROM HZ_PARTIES HZP,

702: l_progress := '010';
703: BEGIN
704: SELECT distinct(HZP.party_id)
705: INTO l_person_id
706: FROM HZ_PARTIES HZP,
707: FND_USER U,
708: PER_ALL_PEOPLE_F PAP,
709: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR
710: WHERE CURR.user_id = U.user_id

Line 800: HZ_PARTIES INIT_P,

796: FROM FUN_TRX_BATCHES FTB,
797: FUN_TRX_HEADERS FTH,
798: XLE_ENTITY_PROFILES XLE,
799: FND_LOOKUP_VALUES LKUP,
800: HZ_PARTIES INIT_P,
801: FUN_TRX_TYPES_VL FTTVL,
802: FND_CURRENCIES_VL FCV,
803: GL_LEDGERS GL,
804: FUN_TRX_BATCHES FTB_ORIG,

Line 809: HZ_PARTIES RECI_P,

805: FUN_TRX_BATCHES FTB_REV,
806: GL_LEDGERS GL1,
807: FUN_TRX_HEADERS FTH_ORIG,
808: FUN_TRX_HEADERS FTH_REV,
809: HZ_PARTIES RECI_P,
810: XLE_ENTITY_PROFILES XLE1,
811: FND_LOOKUP_VALUES LKUP1,
812: FND_GRANTS FG,
813: FND_OBJECT_INSTANCE_SETS FOIS

Line 943: l_person_id HZ_PARTIES.party_id%TYPE;

939: l_progress VARCHAR2(30);
940:
941: l_acc_segment fnd_id_flex_segments.application_column_name%TYPE;
942:
943: l_person_id HZ_PARTIES.party_id%TYPE;
944: l_grantee_key FND_GRANTS.grantee_key%TYPE;
945: BEGIN
946: l_api_name := 'build_account_inquery';
947: l_progress := '000';

Line 961: FROM HZ_PARTIES HZP,

957: l_progress := '010';
958: BEGIN
959: SELECT distinct(HZP.party_id)
960: INTO l_person_id
961: FROM HZ_PARTIES HZP,
962: FND_USER U,
963: PER_ALL_PEOPLE_F PAP,
964: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR
965: WHERE CURR.user_id = U.user_id

Line 1100: HZ_PARTIES INIT_P,

1096: fnd_lookup_values lkup2,
1097: FUN_TRX_BATCHES FTB,
1098: FUN_TRX_BATCHES FTB_REV,
1099: FUN_TRX_BATCHES FTB_ORIG,
1100: HZ_PARTIES INIT_P,
1101: HZ_PARTIES RECI_P,
1102: FUN_TRX_HEADERS FTH,
1103: FUN_TRX_HEADERS FTH_REV,
1104: FUN_TRX_HEADERS FTH_ORIG,

Line 1101: HZ_PARTIES RECI_P,

1097: FUN_TRX_BATCHES FTB,
1098: FUN_TRX_BATCHES FTB_REV,
1099: FUN_TRX_BATCHES FTB_ORIG,
1100: HZ_PARTIES INIT_P,
1101: HZ_PARTIES RECI_P,
1102: FUN_TRX_HEADERS FTH,
1103: FUN_TRX_HEADERS FTH_REV,
1104: FUN_TRX_HEADERS FTH_ORIG,
1105: FUN_TRX_TYPES_VL FTTVL,

Line 1374: l_initiator_name HZ_PARTIES.party_name%TYPE;

1370: l_progress VARCHAR2(5);
1371:
1372: l_para_meaning_list VARCHAR2(2000);
1373:
1374: l_initiator_name HZ_PARTIES.party_name%TYPE;
1375: l_recipient_name HZ_PARTIES.party_name%TYPE;
1376: l_batch_status FND_LOOKUPS.meaning%TYPE;
1377: l_trx_status FND_LOOKUPS.meaning%TYPE;
1378: l_trx_type FUN_TRX_TYPES_VL.trx_type_name%TYPE;

Line 1375: l_recipient_name HZ_PARTIES.party_name%TYPE;

1371:
1372: l_para_meaning_list VARCHAR2(2000);
1373:
1374: l_initiator_name HZ_PARTIES.party_name%TYPE;
1375: l_recipient_name HZ_PARTIES.party_name%TYPE;
1376: l_batch_status FND_LOOKUPS.meaning%TYPE;
1377: l_trx_status FND_LOOKUPS.meaning%TYPE;
1378: l_trx_type FUN_TRX_TYPES_VL.trx_type_name%TYPE;
1379: l_currency FND_CURRENCIES_VL.name%TYPE;

Line 1400: FROM HZ_PARTIES

1396: BEGIN
1397: IF p_para_rec.initiator_id IS NOT NULL THEN
1398: SELECT party_name
1399: INTO l_initiator_name
1400: FROM HZ_PARTIES
1401: WHERE party_id = p_para_rec.initiator_id;
1402: END IF;
1403: IF p_para_rec.recipient_id IS NOT NULL THEN
1404: SELECT party_name

Line 1406: FROM HZ_PARTIES

1402: END IF;
1403: IF p_para_rec.recipient_id IS NOT NULL THEN
1404: SELECT party_name
1405: INTO l_recipient_name
1406: FROM HZ_PARTIES
1407: WHERE party_id = p_para_rec.recipient_id;
1408: END IF;
1409: IF p_para_rec.batch_status IS NOT NULL THEN
1410: SELECT meaning

Line 1632: l_initiator_name HZ_PARTIES.party_name%TYPE;

1628: l_progress VARCHAR2(5);
1629:
1630: l_para_meaning_list VARCHAR2(2000);
1631:
1632: l_initiator_name HZ_PARTIES.party_name%TYPE;
1633: l_recipient_name HZ_PARTIES.party_name%TYPE;
1634: l_batch_status FND_LOOKUPS.meaning%TYPE;
1635: l_trx_status FND_LOOKUPS.meaning%TYPE;
1636: l_acc_type FND_LOOKUPS.meaning%TYPE;

Line 1633: l_recipient_name HZ_PARTIES.party_name%TYPE;

1629:
1630: l_para_meaning_list VARCHAR2(2000);
1631:
1632: l_initiator_name HZ_PARTIES.party_name%TYPE;
1633: l_recipient_name HZ_PARTIES.party_name%TYPE;
1634: l_batch_status FND_LOOKUPS.meaning%TYPE;
1635: l_trx_status FND_LOOKUPS.meaning%TYPE;
1636: l_acc_type FND_LOOKUPS.meaning%TYPE;
1637: l_trx_type FUN_TRX_TYPES_VL.trx_type_name%TYPE;