DBA Data[Home] [Help]

APPS.JMF_SHIKYU_GRP dependencies on HR_ORGANIZATION_INFORMATION

Line 895: FROM HR_ORGANIZATION_INFORMATION hoi,

891: SELECT DISTINCT hoi.organization_id,
892: msib.outsourced_assembly
893: INTO l_tp_organization_id,
894: l_tp_org_item_osa_flag
895: FROM HR_ORGANIZATION_INFORMATION hoi,
896: MTL_SYSTEM_ITEMS_B msib
897: WHERE hoi.org_information_context = 'Customer/Supplier Association'
898: AND hoi.org_information3 = p_vendor_id
899: AND hoi.org_information4 = p_vendor_site_id