DBA Data[Home] [Help]

APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 3564: FROM mtl_item_locations_kfv

3560:
3561: /*Added by sowsubra*/
3562: CURSOR c_validate_subinv_loc_dtl(p_inv_locator_id IN NUMBER, p_org_id IN NUMBER) IS
3563: SELECT subinventory_code, CONCATENATED_SEGMENTS
3564: FROM mtl_item_locations_kfv
3565: WHERE inventory_location_id = p_inv_locator_id
3566: -- jaramana on Feb 14, 2008 for bug 6819370
3567: -- Removed null check on segment19 and segment20
3568: AND organization_id = p_org_id;

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

3569:
3570: /*Added by sowsubra*/
3571: CURSOR c_get_default_loc_dtl(p_org_id IN NUMBER, p_dept_id IN NUMBER) IS
3572: SELECT ds.inv_locator_id, mtl.subinventory_code, mtl.CONCATENATED_SEGMENTS
3573: FROM ahl_department_shifts_v ds, hr_organization_units hou, mtl_item_locations_kfv mtl
3574: WHERE hou.organization_id = p_org_id
3575: AND hou.name = ds.organization_name
3576: AND ds.department_id = p_dept_id
3577: AND hou.organization_id = mtl.organization_id