DBA Data[Home] [Help]

APPS.GML_RECV_TRANS_PKG dependencies on MTL_ITEM_LOCATIONS

Line 1001: FROM mtl_item_locations

997: /* Bug 1969740 */
998: CURSOR get_subinventory_code_cur(vc_ship_to_organization_id NUMBER,
999: vc_inventory_location_id NUMBER) IS
1000: SELECT subinventory_code
1001: FROM mtl_item_locations
1002: WHERE organization_id = vc_ship_to_organization_id
1003: AND inventory_location_id = vc_inventory_location_id
1004: AND (disable_date > sysdate or disable_date is null);
1005: