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 812: l_customer_information HR_ORGANIZATION_INFORMATION.Org_Information1%TYPE;

808: l_receive_date DATE;
809:
810: l_date_flag NUMBER;
811: l_tp_org_id NUMBER;
812: l_customer_information HR_ORGANIZATION_INFORMATION.Org_Information1%TYPE;
813:
814: BEGIN
815: JMF_SHIKYU_UTIL.debug_output
816: (

Line 829: FROM HR_ORGANIZATION_INFORMATION hoi

825: l_customer_information := p_line_ship_to_org_id;
826: BEGIN
827: SELECT hoi.Organization_Id
828: INTO l_tp_org_id
829: FROM HR_ORGANIZATION_INFORMATION hoi
830: WHERE hoi.org_information1 = l_customer_information;
831:
832: EXCEPTION
833: WHEN no_data_found THEN

Line 1415: HR_ORGANIZATION_INFORMATION hoi

1411: INTO
1412: l_customer_id
1413: , l_customer_site_id
1414: FROM
1415: HR_ORGANIZATION_INFORMATION hoi
1416: WHERE hoi.org_information_context = 'Customer/Supplier Association'
1417: AND hoi.organization_id = p_org_inventory_id;
1418: EXCEPTION
1419: WHEN no_data_found THEN

Line 1503: HR_ORGANIZATION_INFORMATION hoi

1499: INTO
1500: l_supplier_id
1501: , l_supplier_site_id
1502: FROM
1503: HR_ORGANIZATION_INFORMATION hoi
1504: WHERE hoi.org_information_context = 'Customer/Supplier Association'
1505: AND hoi.organization_id = p_sold_from_org_id;
1506: EXCEPTION
1507: WHEN no_data_found THEN