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.

[Home] [Help]

APPS.AS_SC_DENORM dependencies on JTF_RS_RESOURCE_EXTNS

Line 447: jtf_rs_resource_extns jrs,

443: sc.opp_forecast_amount,
444: sc.opp_best_forecast_amount
445: From
446: as_sales_stages_all_tl sales,
447: jtf_rs_resource_extns jrs,
448: jtf_rs_groups_tl sg,
449: jtf_rs_groups_tl sg2,
450: as_statuses_vl status,
451: hz_parties cust,

Line 461: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,

457: mtl_system_items_tl mtlsitl,
458: mtl_units_of_measure_tl mtluom,
459: aso_i_sales_credit_types_v ctypes,
460: --as_interest_codes_tl pic, as_interest_codes_tl sic, as_interest_types_tl it,
461: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,
462: jtf_rs_resource_extns jrs2,
463: hr_all_organization_units_tl org,
464: as_period_rates pr, as_period_days pd
465: Where

Line 462: jtf_rs_resource_extns jrs2,

458: mtl_units_of_measure_tl mtluom,
459: aso_i_sales_credit_types_v ctypes,
460: --as_interest_codes_tl pic, as_interest_codes_tl sic, as_interest_types_tl it,
461: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,
462: jtf_rs_resource_extns jrs2,
463: hr_all_organization_units_tl org,
464: as_period_rates pr, as_period_days pd
465: Where
466: ll.lead_id = lead.lead_id

Line 592: jtf_rs_resource_extns jrs,

588: jrs1.source_name created_name,
589: org.name bg_name
590: FROM as_sales_credits_denorm scdh,
591: as_sales_stages_all_tl sales,
592: jtf_rs_resource_extns jrs,
593: jtf_rs_groups_tl sg,
594: jtf_rs_groups_tl sg2,
595: as_statuses_tl status,
596: hz_parties cust,

Line 602: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,

598: ar_lookups arlkp, as_lookups aslkp,
599: mtl_system_items_tl mtlsitl,
600: mtl_units_of_measure_tl mtluom,
601: --as_interest_codes_tl pic, as_interest_codes_tl sic, as_interest_types_tl it,
602: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,
603: jtf_rs_resource_extns jrs2,
604: hr_all_organization_units_tl org
605: WHERE scdh.sales_stage_id = sales.sales_stage_id(+)
606: And sales.language(+) = userenv('LANG')

Line 603: jtf_rs_resource_extns jrs2,

599: mtl_system_items_tl mtlsitl,
600: mtl_units_of_measure_tl mtluom,
601: --as_interest_codes_tl pic, as_interest_codes_tl sic, as_interest_types_tl it,
602: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,
603: jtf_rs_resource_extns jrs2,
604: hr_all_organization_units_tl org
605: WHERE scdh.sales_stage_id = sales.sales_stage_id(+)
606: And sales.language(+) = userenv('LANG')
607: And scdh.status_code = status.status_code