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 3925: ,hr_organization_information hoi

3921: ,po_lines_all pla
3922: ,po_releases_all pra
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

Line 3928: ,hr_organization_information tp_hoi

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
3932: WHERE oola.header_id = ooha.header_id

Line 4097: ,hr_organization_information hoi

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