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_ORGANIZATION_INFORMATION

Line 542: ,hr_organization_information hoi

538: SELECT mp.organization_id
539: ,mp.organization_code
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

Line 578: ,hr_organization_information hoi

574: ,pvs.vendor_site_id --supplier_site_id
575: FROM mtl_interorg_parameters mip
576: ,po_vendors pv
577: ,po_vendor_sites_all pvs
578: ,hr_organization_information hoi
579: ,mtl_parameters mp
580: WHERE mip.from_organization_id = lp_oem_inv_org_id
581: --AND mip.shikyu_enabled_flag = 'Y'
582: AND mip.subcontracting_type in ('B','C') -- 12.1 Buy/Sell Subcontracting Changes

Line 1333: ,HR_ORGANIZATION_INFORMATION hoi -- Add this table to get information of oem

1329: FROM po_headers_all pha
1330: ,po_lines_all pla
1331: ,po_line_locations_all plla
1332: ,MTL_UNITS_OF_MEASURE_TL uom_tl
1333: ,HR_ORGANIZATION_INFORMATION hoi -- Add this table to get information of oem
1334: WHERE pla.po_header_id = pha.po_header_id
1335: AND plla.po_line_id = pla.po_line_id
1336: AND pla.unit_meas_lookup_code = uom_tl.unit_of_measure
1337: AND uom_tl.LANGUAGE = USERENV('LANG')

Line 3922: ,hr_organization_information hoi

3918: ,po_lines_all pla
3919: ,po_releases_all pra
3920: ,po_headers_all pha
3921: ,jmf_shikyu_replenishments jsr
3922: ,hr_organization_information hoi
3923: -- Amy added to fix bug 5583680 start
3924: ,hr_all_organization_units_tl oem_haoutl
3925: ,hr_organization_information tp_hoi
3926: ,po_vendors pv

Line 3925: ,hr_organization_information tp_hoi

3921: ,jmf_shikyu_replenishments jsr
3922: ,hr_organization_information hoi
3923: -- Amy added to fix bug 5583680 start
3924: ,hr_all_organization_units_tl oem_haoutl
3925: ,hr_organization_information tp_hoi
3926: ,po_vendors pv
3927: ,po_vendor_sites_all pvs
3928: -- Amy added to fix bug 5583680 end
3929: WHERE oola.header_id = ooha.header_id

Line 4094: ,hr_organization_information hoi

4090: ,po_lines_all pla
4091: ,po_releases_all pra
4092: ,po_headers_all pha
4093: ,jmf_shikyu_replenishments jsr
4094: ,hr_organization_information hoi
4095: WHERE oola.header_id = ooha.header_id
4096: AND plla.po_line_id = pla.po_line_id
4097: AND plla.po_header_id = pha.po_header_id
4098: AND plla.po_release_id = pra.po_release_id(+)