DBA Data[Home] [Help]

APPS.JMF_SHIKYU_GRP dependencies on HR_ORGANIZATION_INFORMATION

Line 913: FROM HR_ORGANIZATION_INFORMATION hoi,

909: SELECT DISTINCT hoi.organization_id,
910: msib.outsourced_assembly
911: INTO l_tp_organization_id,
912: l_tp_org_item_osa_flag
913: FROM HR_ORGANIZATION_INFORMATION hoi,
914: MTL_SYSTEM_ITEMS_B msib
915: WHERE hoi.org_information_context = 'Customer/Supplier Association'
916: AND hoi.org_information3 = p_vendor_id
917: AND hoi.org_information4 = p_vendor_site_id