APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on AHL_WORKORDER_MTL_TXNS

Line 3057: FROM ahl_workorder_mtl_txns mt, ahl_workorder_operations woo

3053: -- To get latest material issue txn for the item instance.
3054: CURSOR ahl_mtl_txn_csr (p_Item_Instance_Id IN NUMBER,
3055: p_workorder_id IN NUMBER) IS
3056: SELECT workorder_mtl_txn_id
3057: FROM ahl_workorder_mtl_txns mt, ahl_workorder_operations woo
3058: WHERE mt.WORKORDER_OPERATION_ID = woo.WORKORDER_OPERATION_ID
3059: AND TRANSACTION_TYPE_ID = 35 -- issues.
3060: AND woo.workorder_id = p_workorder_id
3061: ORDER by mt.TRANSACTION_DATE DESC, mt.LAST_UPDATE_DATE DESC;