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.AMS_DMEXTRACT_PVT dependencies on HZ_FINANCIAL_REPORTS

Line 972: -- FROM ams_dm_drv_stg drv, hz_financial_numbers hzf, hz_financial_reports hfr

968: SUM(DECODE (hzf.financial_number_name,'PROFIT_BEFORE_TAX',hzf.financial_number,0)) net_profit ,
969: SUM(DECODE (hzf.financial_number_name,'ACCOUNTS_RECEIVABLE',hzf.financial_number,0)) accounts_receivable ,
970: SUM(DECODE (hzf.financial_number_name,'RETAINED_EARNINGS',hzf.financial_number,0)) retained_earnings
971: -- nyostos - Sep 15, 2003 - Global Temp Table
972: -- FROM ams_dm_drv_stg drv, hz_financial_numbers hzf, hz_financial_reports hfr
973: FROM ams_dm_drv_stg_gt drv, hz_financial_numbers hzf, hz_financial_reports hfr
974: WHERE drv.party_id = hfr.party_id(+)
975: AND hfr.status(+) = 'A'
976: AND hfr.consolidated_ind(+) = 'C' -- wen only want consolidated reports

Line 973: FROM ams_dm_drv_stg_gt drv, hz_financial_numbers hzf, hz_financial_reports hfr

969: SUM(DECODE (hzf.financial_number_name,'ACCOUNTS_RECEIVABLE',hzf.financial_number,0)) accounts_receivable ,
970: SUM(DECODE (hzf.financial_number_name,'RETAINED_EARNINGS',hzf.financial_number,0)) retained_earnings
971: -- nyostos - Sep 15, 2003 - Global Temp Table
972: -- FROM ams_dm_drv_stg drv, hz_financial_numbers hzf, hz_financial_reports hfr
973: FROM ams_dm_drv_stg_gt drv, hz_financial_numbers hzf, hz_financial_reports hfr
974: WHERE drv.party_id = hfr.party_id(+)
975: AND hfr.status(+) = 'A'
976: AND hfr.consolidated_ind(+) = 'C' -- wen only want consolidated reports
977: AND hfr.financial_report_id = hzf.financial_report_id(+)

Line 1033: -- FROM ams_dm_drv_stg drv, hz_financial_numbers hzf, hz_financial_reports hfr, hz_relationships hpr

1029: -- NULL capital_type_indicator ,
1030: SUM(DECODE (hzf.financial_number_name,'ACCOUNTS_RECEIVABLE',hzf.financial_number,0)) accounts_receivable ,
1031: SUM(DECODE (hzf.financial_number_name,'RETAINED_EARNINGS',hzf.financial_number,0)) retained_earnings
1032: -- nyostos - Sep 15, 2003 - Global Temp Table
1033: -- FROM ams_dm_drv_stg drv, hz_financial_numbers hzf, hz_financial_reports hfr, hz_relationships hpr
1034: FROM ams_dm_drv_stg_gt drv, hz_financial_numbers hzf, hz_financial_reports hfr, hz_relationships hpr
1035: WHERE drv.party_id = hpr.party_id
1036: AND hpr.status = 'A'
1037: AND hpr.subject_table_name = 'HZ_PARTIES'

Line 1034: FROM ams_dm_drv_stg_gt drv, hz_financial_numbers hzf, hz_financial_reports hfr, hz_relationships hpr

1030: SUM(DECODE (hzf.financial_number_name,'ACCOUNTS_RECEIVABLE',hzf.financial_number,0)) accounts_receivable ,
1031: SUM(DECODE (hzf.financial_number_name,'RETAINED_EARNINGS',hzf.financial_number,0)) retained_earnings
1032: -- nyostos - Sep 15, 2003 - Global Temp Table
1033: -- FROM ams_dm_drv_stg drv, hz_financial_numbers hzf, hz_financial_reports hfr, hz_relationships hpr
1034: FROM ams_dm_drv_stg_gt drv, hz_financial_numbers hzf, hz_financial_reports hfr, hz_relationships hpr
1035: WHERE drv.party_id = hpr.party_id
1036: AND hpr.status = 'A'
1037: AND hpr.subject_table_name = 'HZ_PARTIES'
1038: AND hpr.object_table_name = 'HZ_PARTIES'