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
465: and ll.lead_line_id = sc.lead_line_id
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
637: and ll.lead_line_id = sc.lead_line_id
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
772: And status.language = userenv('LANG')