DBA Data[Home] [Help]

APPS.GME_TRANSACTIONS_PVT dependencies on MTL_TRANSACTION_TYPES

Line 2225: FROM mtl_transaction_types

2221: FETCH get_location INTO l_locator;
2222: CLOSE get_location;
2223: SELECT transaction_type_name
2224: INTO l_type
2225: FROM mtl_transaction_types
2226: WHERE transaction_type_id = l_mmti_rec.transaction_type_id;
2227: IF l_locator IS NOT NULL THEN
2228: gme_common_pvt.log_message ('GME_MATERIAL_STS_INV_SUB_LOC'
2229: ,'TRANSTYPE',l_type,'ITEM',l_item

Line 2547: FROM mtl_transaction_types

2543: WHERE organization_id = gme_common_pvt.g_organization_id
2544: AND inventory_item_id = l_inventory_item_id;
2545: SELECT transaction_type_name
2546: INTO l_type
2547: FROM mtl_transaction_types
2548: WHERE transaction_type_id = p_transaction_type_id;
2549: gme_common_pvt.log_message ('GME_MATERIAL_STS_INV_LOT'
2550: ,'TRANSTYPE',l_type,'ITEM',l_item
2551: ,'LOT',l_mmli_rec.lot_number);