DBA Data[Home] [Help]

APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 613: from mtl_item_locations_kfv

609:
610: -- to get locator_id from locator code
611: CURSOR ahl_locator_csr (p_locator_code in varchar2, p_org_id in number) is
612: select inventory_location_id
613: from mtl_item_locations_kfv
614: where concatenated_segments = p_locator_code
615: and organization_id =p_org_id;
616:
617: */

Line 3148: mtl_item_locations_kfv loc, ahl_workorder_operations awo

3144: csi.inventory_item_id, vst.organization_id, vst.inv_locator_id,
3145: loc.subinventory_code, awo.operation_sequence_num
3146: FROM ahl_prd_dispositions_b disp, csi_item_instances csi,
3147: ahl_workorders wo, ahl_visits_b vst,
3148: mtl_item_locations_kfv loc, ahl_workorder_operations awo
3149: WHERE disp.instance_id = csi.instance_id
3150: AND disp.part_change_id = p_part_change_id
3151: AND disp.workorder_id = wo.workorder_id
3152: AND wo.visit_id = vst.visit_id