APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on HR_ORGANIZATION_INFORMATION

Line 119: hr_organization_information hoi,

115: --find all TP inventory by org_id
116: CURSOR all_inventory_c IS
117: SELECT haou.organization_id
118: FROM mtl_parameters mp,
119: hr_organization_information hoi,
120: hr_all_organization_units haou,
121: HR_ALL_ORGANIZATION_UNITS_TL haoutl
122: WHERE mp.organization_id = hoi.organization_id
123: AND haou.organization_id = hoi.organization_id

Line 821: --l_customer_information HR_ORGANIZATION_INFORMATION.Org_Information1%TYPE;

817: l_date_flag NUMBER;
818: l_tp_org_id NUMBER;
819:
820: --Bugfix 10281833: Variable l_customer_information is not needed
821: --l_customer_information HR_ORGANIZATION_INFORMATION.Org_Information1%TYPE;
822:
823: BEGIN
824: JMF_SHIKYU_UTIL.debug_output
825: (

Line 839: FROM HR_ORGANIZATION_INFORMATION hoi

835: l_customer_information := p_line_ship_to_org_id;
836: BEGIN
837: SELECT hoi.Organization_Id
838: INTO l_tp_org_id
839: FROM HR_ORGANIZATION_INFORMATION hoi
840: WHERE hoi.org_information1 = l_customer_information;
841:
842: EXCEPTION
843: WHEN no_data_found THEN

Line 1435: HR_ORGANIZATION_INFORMATION hoi

1431: INTO
1432: l_customer_id
1433: , l_customer_site_id
1434: FROM
1435: HR_ORGANIZATION_INFORMATION hoi
1436: WHERE hoi.org_information_context = 'Customer/Supplier Association'
1437: AND hoi.organization_id = p_org_inventory_id;
1438: EXCEPTION
1439: WHEN no_data_found THEN

Line 1523: HR_ORGANIZATION_INFORMATION hoi

1519: INTO
1520: l_supplier_id
1521: , l_supplier_site_id
1522: FROM
1523: HR_ORGANIZATION_INFORMATION hoi
1524: WHERE hoi.org_information_context = 'Customer/Supplier Association'
1525: AND hoi.organization_id = p_sold_from_org_id;
1526: EXCEPTION
1527: WHEN no_data_found THEN