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.JAI_PO_PROC_PKG dependencies on HR_LOCATIONS

Line 633: FROM Hr_Locations

629: WHERE Unit_Of_Measure = v_uom_measure;
630:
631: CURSOR Fetch_Org_Id_Cur IS
632: SELECT Inventory_Organization_Id
633: FROM Hr_Locations
634: WHERE Location_Id = v_ship_loc_id;
635:
636: CURSOR fetch_book_id_cur
637: IS

Line 4853: FROM Hr_Locations

4849: -- Pick up Line Location Details as well.
4850:
4851: CURSOR c_inventory_org_id(p_ship_to_location_id IN NUMBER) IS
4852: SELECT Inventory_Organization_Id
4853: FROM Hr_Locations
4854: WHERE Location_Id = p_ship_to_location_id;
4855:
4856: v_inventory_org_id HR_LOCATIONS.Inventory_Organization_Id%TYPE;
4857: v_line_loc_cnt NUMBER;

Line 4856: v_inventory_org_id HR_LOCATIONS.Inventory_Organization_Id%TYPE;

4852: SELECT Inventory_Organization_Id
4853: FROM Hr_Locations
4854: WHERE Location_Id = p_ship_to_location_id;
4855:
4856: v_inventory_org_id HR_LOCATIONS.Inventory_Organization_Id%TYPE;
4857: v_line_loc_cnt NUMBER;
4858: v_ship_to_organization_id NUMBER;
4859: v_ship_to_location_id NUMBER;
4860: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;

Line 5824: FROM Hr_Locations

5820: AND Line_Location_Id = linelocid;
5821:
5822: CURSOR Fetch_Org_Id_Cur IS
5823: SELECT Inventory_Organization_id
5824: FROM Hr_Locations
5825: WHERE Location_Id = lv_ship_to_location_id ;
5826:
5827: v_seq_val NUMBER;
5828: l_api_name CONSTANT VARCHAR2(30) := 'copy_agreement_taxes';

Line 8281: FROM Hr_Locations

8277: -- Pick up Line Location Details as well.
8278:
8279: CURSOR c_inventory_org_id(p_ship_to_location_id IN NUMBER) IS
8280: SELECT Inventory_Organization_Id
8281: FROM Hr_Locations
8282: WHERE Location_Id = p_ship_to_location_id;
8283:
8284: v_inventory_org_id HR_LOCATIONS.Inventory_Organization_Id%TYPE;
8285: v_line_loc_cnt NUMBER;

Line 8284: v_inventory_org_id HR_LOCATIONS.Inventory_Organization_Id%TYPE;

8280: SELECT Inventory_Organization_Id
8281: FROM Hr_Locations
8282: WHERE Location_Id = p_ship_to_location_id;
8283:
8284: v_inventory_org_id HR_LOCATIONS.Inventory_Organization_Id%TYPE;
8285: v_line_loc_cnt NUMBER;
8286: v_ship_to_organization_id NUMBER;
8287: v_ship_to_location_id NUMBER;
8288: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;