DBA Data[Home] [Help]

APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 3518: FROM mtl_item_locations_kfv

3514:
3515: /*Added by sowsubra*/
3516: CURSOR c_validate_subinv_loc_dtl(p_inv_locator_id IN NUMBER, p_org_id IN NUMBER) IS
3517: SELECT subinventory_code, CONCATENATED_SEGMENTS
3518: FROM mtl_item_locations_kfv
3519: WHERE inventory_location_id = p_inv_locator_id
3520: -- jaramana on Feb 14, 2008 for bug 6819370
3521: -- Removed null check on segment19 and segment20
3522: AND organization_id = p_org_id;

Line 3527: FROM ahl_department_shifts_v ds, hr_organization_units hou, mtl_item_locations_kfv mtl

3523:
3524: /*Added by sowsubra*/
3525: CURSOR c_get_default_loc_dtl(p_org_id IN NUMBER, p_dept_id IN NUMBER) IS
3526: SELECT ds.inv_locator_id, mtl.subinventory_code, mtl.CONCATENATED_SEGMENTS
3527: FROM ahl_department_shifts_v ds, hr_organization_units hou, mtl_item_locations_kfv mtl
3528: WHERE hou.organization_id = p_org_id
3529: AND hou.name = ds.organization_name
3530: AND ds.department_id = p_dept_id
3531: AND hou.organization_id = mtl.organization_id