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.JMF_SHIKYU_RPT_CFR_PVT dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 196: FROM hr_all_organization_units_tl haoutl

192: IF p_organization_id IS NOT NULL
193: THEN
194: SELECT name
195: INTO x_organization_name
196: FROM hr_all_organization_units_tl haoutl
197: WHERE haoutl.organization_id = p_organization_id
198: AND haoutl.LANGUAGE = USERENV('LANG');
199: END IF;
200:

Line 260: l_oem_inv_org_name_from hr_all_organization_units_tl.name%TYPE := NULL;

256: l_conc_succ BOOLEAN;
257: l_functional_currency gl_ledgers.currency_code%TYPE;
258:
259: -- Bug 5665334
260: l_oem_inv_org_name_from hr_all_organization_units_tl.name%TYPE := NULL;
261: l_oem_inv_org_name_to hr_all_organization_units_tl.name%TYPE := NULL;
262:
263: BEGIN
264:

Line 261: l_oem_inv_org_name_to hr_all_organization_units_tl.name%TYPE := NULL;

257: l_functional_currency gl_ledgers.currency_code%TYPE;
258:
259: -- Bug 5665334
260: l_oem_inv_org_name_from hr_all_organization_units_tl.name%TYPE := NULL;
261: l_oem_inv_org_name_to hr_all_organization_units_tl.name%TYPE := NULL;
262:
263: BEGIN
264:
265: --Amy add for fixing bug 5391412 start

Line 544: ,HR_ALL_ORGANIZATION_UNITS_TL haoutl

540: ,haoutl.NAME
541: FROM mtl_parameters mp
542: ,hr_organization_information hoi
543: ,hr_all_organization_units haou
544: ,HR_ALL_ORGANIZATION_UNITS_TL haoutl
545: WHERE mp.organization_id = hoi.organization_id
546: AND haou.organization_id = hoi.organization_id
547: AND haou.organization_id = haoutl.organization_id
548: AND NVL(mp.trading_partner_org_flag,'N') = 'N'

Line 3927: ,hr_all_organization_units_tl oem_haoutl

3923: ,po_headers_all pha
3924: ,jmf_shikyu_replenishments jsr
3925: ,hr_organization_information hoi
3926: -- Amy added to fix bug 5583680 start
3927: ,hr_all_organization_units_tl oem_haoutl
3928: ,hr_organization_information tp_hoi
3929: ,po_vendors pv
3930: ,po_vendor_sites_all pvs
3931: -- Amy added to fix bug 5583680 end

Line 4345: ,HR_ALL_ORGANIZATION_UNITS_TL haou

4341: ,jscrt.value2 value2
4342: ,jscrt.value3 value3
4343: ,jscrt.transaction_id transaction_id
4344: FROM jmf_shikyu_cfr_rpt_temp jscrt
4345: ,HR_ALL_ORGANIZATION_UNITS_TL haou
4346: WHERE jscrt.oem_inv_org_id = haou.organization_id
4347: AND jscrt.rpt_data_type = CFR_CRUDE_DATA
4348: AND haou.language = USERENV('LANG')
4349: GROUP BY jscrt.rpt_mode