DBA Data[Home] [Help]

APPS.GME_LPN_MOBILE_TXN dependencies on MTL_SYSTEM_ITEMS_KFV

Line 461: FROM gme_material_details gmd, mtl_item_locations_kfv mil, gme_batch_header gbh, mtl_system_items_kfv msi

457: IS
458:
459: CURSOR Cur_sub_loc IS
460: SELECT gbh.batch_no, msi.concatenated_segments, gmd.subinventory, mil.concatenated_segments, inventory_location_id
461: FROM gme_material_details gmd, mtl_item_locations_kfv mil, gme_batch_header gbh, mtl_system_items_kfv msi
462: WHERE gmd.organization_id = p_org_id
463: AND gmd.batch_id = p_batch_id
464: AND gmd.material_detail_id = p_material_dtl_id
465: AND gmd.locator_id = mil.inventory_location_id