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

Line 274: and parent_table_name = 'HZ_PARTIES'

270: WHERE party_id in
271: ( SELECT child_id
272: from hz_hierarchy_nodes
273: where parent_object_type = 'ORGANIZATION'
274: and parent_table_name = 'HZ_PARTIES'
275: and child_object_type = 'ORGANIZATION'
276: and parent_id = p_party_id
277: and effective_start_date <= sysdate
278: and effective_end_date >= sysdate

Line 496: and parent_table_name = ''HZ_PARTIES''

492: WHERE party_id in
493: ( SELECT child_id
494: from hz_hierarchy_nodes
495: where parent_object_type = ''ORGANIZATION''
496: and parent_table_name = ''HZ_PARTIES''
497: and child_object_type = ''ORGANIZATION''
498: and parent_id = :3
499: and effective_start_date <= sysdate
500: and effective_end_date >= sysdate

Line 578: and parent_table_name = ''HZ_PARTIES''

574: WHERE party_id in
575: ( SELECT child_id
576: from hz_hierarchy_nodes
577: where parent_object_type = ''ORGANIZATION''
578: and parent_table_name = ''HZ_PARTIES''
579: and child_object_type = ''ORGANIZATION''
580: and parent_id = :3
581: and effective_start_date <= sysdate
582: and effective_end_date >= sysdate

Line 767: AND parent_table_name = 'HZ_PARTIES'

763: WHERE party_id in
764: ( SELECT child_id
765: FROM hz_hierarchy_nodes
766: WHERE parent_object_type = 'ORGANIZATION'
767: AND parent_table_name = 'HZ_PARTIES'
768: AND child_object_type = 'ORGANIZATION'
769: AND parent_id = p_party_id
770: AND effective_start_date <= sysdate
771: AND effective_end_date >= sysdate

Line 891: and parent_table_name = 'HZ_PARTIES'

887: WHERE party_id in
888: ( SELECT child_id
889: from hz_hierarchy_nodes
890: where parent_object_type = 'ORGANIZATION'
891: and parent_table_name = 'HZ_PARTIES'
892: and child_object_type = 'ORGANIZATION'
893: and parent_id = p_party_id
894: and effective_start_date <= sysdate
895: and effective_end_date >= sysdate

Line 924: and parent_table_name = 'HZ_PARTIES'

920: WHERE party_id in
921: ( SELECT child_id
922: from hz_hierarchy_nodes
923: where parent_object_type = 'ORGANIZATION'
924: and parent_table_name = 'HZ_PARTIES'
925: and child_object_type = 'ORGANIZATION'
926: and parent_id = p_party_id
927: and effective_start_date <= sysdate
928: and effective_end_date >= sysdate

Line 1142: and parent_table_name = 'HZ_PARTIES'

1138: WHERE party_id in
1139: ( SELECT child_id
1140: from hz_hierarchy_nodes
1141: where parent_object_type = 'ORGANIZATION'
1142: and parent_table_name = 'HZ_PARTIES'
1143: and child_object_type = 'ORGANIZATION'
1144: and parent_id = p_party_id
1145: and effective_start_date <= sysdate
1146: and effective_end_date >= sysdate

Line 1971: CURSOR c_hz_parties IS

1967: SELECT trx_credit_limit, overall_credit_limit
1968: FROM hz_cust_profile_amts
1969: WHERE cust_acct_profile_amt_id = p_cust_acct_profile_amt_id;
1970:
1971: CURSOR c_hz_parties IS
1972: SELECT tax_name, year_established,
1973: sic_code, -- industrial code
1974: sic_code_type, -- industrial code type
1975: url,

Line 1978: FROM hz_parties

1974: sic_code_type, -- industrial code type
1975: url,
1976: employees_total,
1977: duns_number
1978: FROM hz_parties
1979: WHERE party_id = p_party_id;
1980:
1981:
1982: CURSOR c_credit_requests IS

Line 2043: FOR c_hz_parties_rec IN c_hz_parties

2039: p_resultout => l_resultout);
2040: exit;
2041: END LOOP;
2042:
2043: FOR c_hz_parties_rec IN c_hz_parties
2044: LOOP
2045:
2046: build_case_folder_details(
2047: p_case_folder_id => p_case_folder_id,

Line 2049: p_data_point_value => c_hz_parties_rec.tax_name,

2045:
2046: build_case_folder_details(
2047: p_case_folder_id => p_case_folder_id,
2048: p_data_point_id => 89,
2049: p_data_point_value => c_hz_parties_rec.tax_name,
2050: p_mode => p_mode,
2051: p_error_msg => l_errmsg,
2052: p_resultout => l_resultout);
2053:

Line 2057: p_data_point_value => c_hz_parties_rec.sic_code_type,

2053:
2054: build_case_folder_details(
2055: p_case_folder_id => p_case_folder_id,
2056: p_data_point_id => 93,
2057: p_data_point_value => c_hz_parties_rec.sic_code_type,
2058: p_mode => p_mode,
2059: p_error_msg => l_errmsg,
2060: p_resultout => l_resultout);
2061: build_case_folder_details(

Line 2064: p_data_point_value => c_hz_parties_rec.sic_code,

2060: p_resultout => l_resultout);
2061: build_case_folder_details(
2062: p_case_folder_id => p_case_folder_id,
2063: p_data_point_id => 92,
2064: p_data_point_value => c_hz_parties_rec.sic_code,
2065: p_mode => p_mode,
2066: p_error_msg => l_errmsg,
2067: p_resultout => l_resultout);
2068: build_case_folder_details(

Line 2071: p_data_point_value => c_hz_parties_rec.url,

2067: p_resultout => l_resultout);
2068: build_case_folder_details(
2069: p_case_folder_id => p_case_folder_id,
2070: p_data_point_id => 100,
2071: p_data_point_value => c_hz_parties_rec.url,
2072: p_mode => p_mode,
2073: p_error_msg => l_errmsg,
2074: p_resultout => l_resultout);
2075: build_case_folder_details(

Line 2078: p_data_point_value => c_hz_parties_rec.employees_total,

2074: p_resultout => l_resultout);
2075: build_case_folder_details(
2076: p_case_folder_id => p_case_folder_id,
2077: p_data_point_id => 101,
2078: p_data_point_value => c_hz_parties_rec.employees_total,
2079: p_mode => p_mode,
2080: p_error_msg => l_errmsg,
2081: p_resultout => l_resultout);
2082: build_case_folder_details(

Line 2085: p_data_point_value => c_hz_parties_rec.duns_number,

2081: p_resultout => l_resultout);
2082: build_case_folder_details(
2083: p_case_folder_id => p_case_folder_id,
2084: p_data_point_id => 183,
2085: p_data_point_value => c_hz_parties_rec.duns_number,
2086: p_mode => p_mode,
2087: p_error_msg => l_errmsg,
2088: p_resultout => l_resultout);
2089: exit;

Line 4415: l_hq_branch_ind hz_parties.hq_branch_ind%type;

4411: l_relationship_id hz_relationships.relationship_id%TYPE;
4412: l_report_type hz_financial_reports.type_of_financial_report%TYPE := 'BALANCE_SHEET';
4413: l_credit_rating_id NUMBER;
4414: l_financial_report_id NUMBER;
4415: l_hq_branch_ind hz_parties.hq_branch_ind%type;
4416: l_balance_sheet_id NUMBER;
4417: l_income_statement_id NUMBER;
4418: l_tangible_net_worth_id NUMBER;
4419: l_annual_sales_volume_id NUMBER;

Line 4430: AND rel.subject_table_name = 'HZ_PARTIES'

4426: 'DOMESTIC_ULTIMATE_OF','GLOBAL_ULTIMATE_OF')
4427: AND rel.actual_content_source = 'DNB'
4428: AND rel.start_date <= sysdate
4429: AND NVL(rel.end_date, to_date('12/31/4712','MM/DD/YYYY')) > sysdate
4430: AND rel.subject_table_name = 'HZ_PARTIES'
4431: AND rel.object_table_name = 'HZ_PARTIES';
4432:
4433: CURSOR c_contact_point IS
4434: SELECT contact_point_id, phone_line_type

Line 4431: AND rel.object_table_name = 'HZ_PARTIES';

4427: AND rel.actual_content_source = 'DNB'
4428: AND rel.start_date <= sysdate
4429: AND NVL(rel.end_date, to_date('12/31/4712','MM/DD/YYYY')) > sysdate
4430: AND rel.subject_table_name = 'HZ_PARTIES'
4431: AND rel.object_table_name = 'HZ_PARTIES';
4432:
4433: CURSOR c_contact_point IS
4434: SELECT contact_point_id, phone_line_type
4435: FROM hz_contact_points

Line 4436: WHERE owner_table_name = 'HZ_PARTIES'

4432:
4433: CURSOR c_contact_point IS
4434: SELECT contact_point_id, phone_line_type
4435: FROM hz_contact_points
4436: WHERE owner_table_name = 'HZ_PARTIES'
4437: AND owner_table_id = p_party_id
4438: AND contact_point_type = 'PHONE'
4439: AND actual_content_source = 'DNB'
4440: AND phone_line_type in ('FAX','GEN')

Line 4486: FROM hz_parties

4482: -- Get information from hz_party
4483: BEGIN
4484: SELECT hq_branch_ind
4485: INTO l_hq_branch_ind
4486: FROM hz_parties
4487: WHERE party_id = p_party_id;
4488:
4489: populate_dnb_data(
4490: p_case_folder_id => p_case_folder_id,

Line 4491: p_source_table_name => 'HZ_PARTIES',

4487: WHERE party_id = p_party_id;
4488:
4489: populate_dnb_data(
4490: p_case_folder_id => p_case_folder_id,
4491: p_source_table_name => 'HZ_PARTIES',
4492: p_source_key => p_party_id,
4493: p_source_key_column_name => 'PARTY_ID',
4494: p_mode => p_mode);
4495: EXCEPTION

Line 4500: p_error_msg := 'SqlError While retrieving Data from HZ_PARTIES '||sqlerrm;

4496: WHEN NO_DATA_FOUND THEN
4497: NULL;
4498: WHEN OTHERS THEN
4499: p_resultout := 1;
4500: p_error_msg := 'SqlError While retrieving Data from HZ_PARTIES '||sqlerrm;
4501: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
4502: return;
4503: END;
4504:

Line 4739: l_party_number hz_parties.party_number%type;

4735: l_deno_dso number := 1;
4736: l_deno_ddso number := 1;
4737: l_numerator_dso number;
4738: l_numerator_ddso number;
4739: l_party_number hz_parties.party_number%type;
4740: l_score number;
4741:
4742:
4743:

Line 4874: and parent_table_name = 'HZ_PARTIES'

4870: WHERE party_id in
4871: ( SELECT child_id
4872: from hz_hierarchy_nodes
4873: where parent_object_type = 'ORGANIZATION'
4874: and parent_table_name = 'HZ_PARTIES'
4875: and child_object_type = 'ORGANIZATION'
4876: and parent_id = p_party_id
4877: and effective_start_date <= sysdate
4878: and effective_end_date >= sysdate

Line 5246: and parent_table_name = 'HZ_PARTIES'

5242: WHERE party_id in
5243: ( SELECT child_id
5244: from hz_hierarchy_nodes
5245: where parent_object_type = 'ORGANIZATION'
5246: and parent_table_name = 'HZ_PARTIES'
5247: and child_object_type = 'ORGANIZATION'
5248: and parent_id = p_party_id
5249: and effective_start_date <= sysdate
5250: and effective_end_date >= sysdate

Line 5500: and parent_table_name = 'HZ_PARTIES'

5496: WHERE party_id in
5497: ( SELECT child_id
5498: from hz_hierarchy_nodes
5499: where parent_object_type = 'ORGANIZATION'
5500: and parent_table_name = 'HZ_PARTIES'
5501: and child_object_type = 'ORGANIZATION'
5502: and parent_id = p_party_id
5503: and effective_start_date <= sysdate
5504: and effective_end_date >= sysdate

Line 5604: and parent_table_name = 'HZ_PARTIES'

5600: WHERE party_id in
5601: ( SELECT child_id
5602: from hz_hierarchy_nodes
5603: where parent_object_type = 'ORGANIZATION'
5604: and parent_table_name = 'HZ_PARTIES'
5605: and child_object_type = 'ORGANIZATION'
5606: and parent_id = p_party_id
5607: and effective_start_date <= sysdate
5608: and effective_end_date >= sysdate

Line 6288: and parent_table_name = 'HZ_PARTIES'

6284: WHERE party_id in
6285: ( SELECT child_id
6286: from hz_hierarchy_nodes
6287: where parent_object_type = 'ORGANIZATION'
6288: and parent_table_name = 'HZ_PARTIES'
6289: and child_object_type = 'ORGANIZATION'
6290: and parent_id = p_party_id
6291: and effective_start_date <= sysdate
6292: and effective_end_date >= sysdate