DBA Data[Home] [Help]

APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 580: from mtl_item_locations_kfv

576:
577: -- to get locator_id from locator code
578: CURSOR ahl_locator_csr (p_locator_code in varchar2, p_org_id in number) is
579: select inventory_location_id
580: from mtl_item_locations_kfv
581: where concatenated_segments = p_locator_code
582: and organization_id =p_org_id;
583:
584: */

Line 3091: mtl_item_locations_kfv loc, ahl_workorder_operations awo

3087: csi.inventory_item_id, vst.organization_id, vst.inv_locator_id,
3088: loc.subinventory_code, awo.operation_sequence_num
3089: FROM ahl_prd_dispositions_b disp, csi_item_instances csi,
3090: ahl_workorders wo, ahl_visits_b vst,
3091: mtl_item_locations_kfv loc, ahl_workorder_operations awo
3092: WHERE disp.instance_id = csi.instance_id
3093: AND disp.part_change_id = p_part_change_id
3094: AND disp.workorder_id = wo.workorder_id
3095: AND wo.visit_id = vst.visit_id