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.FV_FACTS1_GL_PKG dependencies on HZ_CUST_ACCOUNTS_ALL

Line 1227: FROM hz_cust_accounts_all c

1223: c.account_name
1224: INTO l_vendor_type,
1225: l_elim_dept ,
1226: l_recipient_name
1227: FROM hz_cust_accounts_all c
1228: WHERE c.cust_account_id = to_number(p_reference_7);
1229:
1230: l_cust_vend_type := 'C';
1231: ELSE

Line 1851: FROM hz_cust_accounts_all c

1847: p_party_info_tab(i).vendor_type ,
1848: p_party_info_tab(i).elim_dept ,
1849: p_party_info_tab(i).recipient_name,
1850: P_party_info_tab(i).party_line_amount
1851: FROM hz_cust_accounts_all c
1852: WHERE c.cust_account_id = other_source_rec.party_id;
1853:
1854: p_party_info_tab(i).cust_vend_type := 'C';
1855: EXCEPTION

Line 1857: FV_UTILITY.LOG_MESG('No data found in hz_cust_accounts_all for party_id: '|| other_source_rec.party_id);

1853:
1854: p_party_info_tab(i).cust_vend_type := 'C';
1855: EXCEPTION
1856: WHEN NO_DATA_FOUND THEN
1857: FV_UTILITY.LOG_MESG('No data found in hz_cust_accounts_all for party_id: '|| other_source_rec.party_id);
1858: p_party_info_tab(i).party_id := other_source_rec.party_id;
1859: p_party_info_tab(i).cust_vend_type := 'C';
1860: P_party_info_tab(i).party_line_amount := other_source_rec.amount;
1861: p_party_info_tab(i).recipient_name := 'Other';

Line 1959: FV_UTILITY.LOG_MESG('Query hz_cust_accounts_all-> '||gbl_cust_attribute);

1955: END;
1956: ELS*/
1957: IF p_entity_code = 'PROJECTS' THEN
1958: BEGIN
1959: FV_UTILITY.LOG_MESG('Query hz_cust_accounts_all-> '||gbl_cust_attribute);
1960:
1961: SELECT c.party_id ,
1962: c.customer_class_code,
1963: DECODE(gbl_cust_attribute, 'ATTRIBUTE1', C.ATTRIBUTE1, 'ATTRIBUTE2',

Line 1977: FROM hz_cust_accounts_all c

1973: p_party_info_tab(i).vendor_type ,
1974: p_party_info_tab(i).elim_dept ,
1975: p_party_info_tab(i).recipient_name,
1976: P_party_info_tab(i).party_line_amount
1977: FROM hz_cust_accounts_all c
1978: WHERE c.cust_account_id = project_source_rec.party_id;
1979:
1980: p_party_info_tab(i).cust_vend_type := 'C';
1981: EXCEPTION

Line 1983: FV_UTILITY.LOG_MESG('No data found in hz_cust_accounts_all for party_id: '|| project_source_rec.party_id);

1979:
1980: p_party_info_tab(i).cust_vend_type := 'C';
1981: EXCEPTION
1982: WHEN NO_DATA_FOUND THEN
1983: FV_UTILITY.LOG_MESG('No data found in hz_cust_accounts_all for party_id: '|| project_source_rec.party_id);
1984: p_party_info_tab(i).party_id := project_source_rec.party_id;
1985: p_party_info_tab(i).cust_vend_type := 'C';
1986: P_party_info_tab(i).party_line_amount := project_source_rec.amount;
1987: p_party_info_tab(i).recipient_name := 'Other';