DBA Data[Home] [Help]

APPS.GME_LPN_MOBILE_TXN dependencies on MTL_SYSTEM_ITEMS_KFV

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

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