APPS.AS_SC_DENORM dependencies on JTF_RS_RESOURCE_EXTNS

Line 445: jtf_rs_resource_extns jrs,

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

Line 459: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,

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

Line 460: jtf_rs_resource_extns jrs2,

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

Line 617: jtf_rs_resource_extns jrs,

613: sc.opp_forecast_amount,
614: sc.opp_best_forecast_amount
615: From
616: as_sales_stages_all_tl sales,
617: jtf_rs_resource_extns jrs,
618: jtf_rs_groups_tl sg,
619: jtf_rs_groups_tl sg2,
620: as_statuses_vl status,
621: hz_parties cust,

Line 631: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,

627: mtl_system_items_tl mtlsitl,
628: mtl_units_of_measure_tl mtluom,
629: aso_i_sales_credit_types_v ctypes,
630: --as_interest_codes_tl pic, as_interest_codes_tl sic, as_interest_types_tl it,
631: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,
632: jtf_rs_resource_extns jrs2,
633: hr_all_organization_units_tl org,
634: as_period_rates pr, as_period_days pd
635: Where

Line 632: jtf_rs_resource_extns jrs2,

628: mtl_units_of_measure_tl mtluom,
629: aso_i_sales_credit_types_v ctypes,
630: --as_interest_codes_tl pic, as_interest_codes_tl sic, as_interest_types_tl it,
631: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,
632: jtf_rs_resource_extns jrs2,
633: hr_all_organization_units_tl org,
634: as_period_rates pr, as_period_days pd
635: Where
636: ll.lead_id = lead.lead_id

Line 756: jtf_rs_resource_extns jrs,

752: jrs1.source_name created_name,
753: org.name bg_name
754: FROM as_sales_credits_denorm scdh,
755: as_sales_stages_all_tl sales,
756: jtf_rs_resource_extns jrs,
757: jtf_rs_groups_tl sg,
758: jtf_rs_groups_tl sg2,
759: as_statuses_tl status,
760: hz_parties cust,

Line 766: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,

762: ar_lookups arlkp, as_lookups aslkp,
763: mtl_system_items_tl mtlsitl,
764: mtl_units_of_measure_tl mtluom,
765: --as_interest_codes_tl pic, as_interest_codes_tl sic, as_interest_types_tl it,
766: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,
767: jtf_rs_resource_extns jrs2,
768: hr_all_organization_units_tl org
769: WHERE scdh.sales_stage_id = sales.sales_stage_id(+)
770: And sales.language(+) = userenv('LANG')

Line 767: jtf_rs_resource_extns jrs2,

763: mtl_system_items_tl mtlsitl,
764: mtl_units_of_measure_tl mtluom,
765: --as_interest_codes_tl pic, as_interest_codes_tl sic, as_interest_types_tl it,
766: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,
767: jtf_rs_resource_extns jrs2,
768: hr_all_organization_units_tl org
769: WHERE scdh.sales_stage_id = sales.sales_stage_id(+)
770: And sales.language(+) = userenv('LANG')
771: And scdh.status_code = status.status_code